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

Reply via email to