Re: Let join syntax

On Mon, 16 Jun 2003 12:34:34 +0200, "Nicolas JOUANIN"
<n(dot)jouanin(at)regie-france(dot)com> wrote:
>from
> coh x0 , cpy x1 ,bra x2 ,
> cur x3 ,tad x4 LEFT OUTER JOIN sec x5 on x5.thr_id=x4.thr_id AND
>x5.usr_id=x0.usr_id AND [...]
>
>Unfortunatelly, postgres returns me the following error :
> Error: ERROR: Relation "x0" does not exist

Yes, because the LEFT OUTER JOIN only sees x4 and x5. I have not
analysed all your join conditions, but

FROM
coh x0 INNER JOIN cpy x1 ON [...] INNER JOIN bra x2 ON [...]
INNER JOIN cur x3 ON [...] INNER JOIN tad x4 ON [...]
LEFT JOIN sec x5 ON [...]

might work. If there is nothing to join x1, x2, x3, x4 on, you could
try to put x5 to the front and use RIGHT JOINs ...

Servus
Manfred