Re: change the order of FROM selection to make query work

Am 26.9.2006 schrieb "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>> FROM ticket as t, permission as perm, enum as p
>> LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name =
>> 'fachabteilung')
>
>The above is, plain and simple, wrong. According to the SQL spec,
>JOIN binds more tightly than comma in a FROM-list, so what you had was
>
>FROM ..., (enum as p
> LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name =
> 'fachabteilung'))
>
>which of course fails because only p and c are visible in the JOIN's
>ON condition. You fixed it by moving "t" to become part of the JOIN
>structure.

ok, lesson learned.
thank you!

cheers,
thomas