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.