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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
