Re: Repost: Syntax - or unavailability of same - for variable join??? Can anyone help? - Mailing list pgsql-general

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;