Re: Can you help with this JOIN? - Mailing list pgsql-sql

On 30 May 2002, Wei Weng wrote:

> But how do I write the LEFT OUTER JOIN if I don't do explicit JOINs on
> the other tables? Can I just do
>
> SELECT x FROM a, b, c, LEFT OUTER JOIN d ON (d.id = a.id)?

I think you'd need to write
SELECT x FROM b,c,a LEFT OUTER JOIN d ON (d.id = a.id)

That should force the outer join first, but give flexibility for the rest
of the joins.