Am 26.9.2006 schrieb "Tom Lane" <tgl@sss.pgh.pa.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