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;