Re: BUG ? or SQL miss understanding ? - Mailing list pgsql-general

On Wed, 28 Apr 2004 12:33:15 +0300, "Bogdan Vatkov"
<bvatkov@globaltech-bg.com> wrote:
>SQL error:
>ERROR:  JOIN/ON clause refers to "vras_audio_records", which is not part of JOIN

In
    SELECT ... FROM a, b LEFT JOIN c ON (a.id = ...)

the LEFT JOIN operator has higher precedence than the comma, so "a" is
not part of the JOIN.  Better use ANSI syntax consistently:

    SELECT ... FROM a INNER JOIN b ON (....)
                       LEFT JOIN c ON (....)

Servus
 Manfred