I'll have a look at that; thank you very much for taking the time to reply. :)
Ben On Mon, 16 Feb 2004 22:03:22 -0800, Greg Patnude wrote: > You might have better success with the form of HAVING and appropriate use of > OR IS NULL as opposed to strict JOIN and WHERE conditions... > > Similar to... > > SELECT A.a, B.b, C.c FROM A, B, C > HAVING (A.b = B.b OR B.b IS NULL) > GROUP BY A.b; ---------------------------(end of broadcast)--------------------------- TIP 3: 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