On Jan 24, 2006, at 20:00 , Alban Hertroys wrote:
Though this does give the right results, I would have liked to be able to use NOT HAVING. Or is there a way using HAVING that would give the same results? I'm quite sure HAVING sort_order <> 1 doesn't mean the same thing.
Why are you so sure? It seems to me that NOT HAVING sort_order = 1 and HAVING sort_order <> 1 would mean semantically the same thing. Can you show that HAVING sort_order <> 1 gives incorrect results?
Michael Glaesemann grzm myrealbox com
