Thread: BUG ? or SQL miss understanding ?

Any idea for this ?! thanx in advance.

SQL error:
ERROR:  JOIN/ON clause refers to "vras_audio_records", which is not part of JOIN

In statement:
set search_path = excel,audio_records;
SELECT vras_audio_records.vras_id AS VRASID,vras_audio_records.audio_record_id AS ANNID, (announcements.description || ' - ' || languages.name) AS ANNNAME

FROM 

vras_audio_records, (SELECT announcements.description,languages.name from
announcements,
languages,
announcement_records,
audio_records
WHERE
audio_records.id = announcement_records.audio_record_id
AND announcements.id = announcement_records.announcement_id
AND languages.id = announcement_records.language_id
AND vras_audio_records.audio_record_id = audio_records.id
) AS AA


LEFT JOIN (
audio_records_groups_vras 
CROSS JOIN audio_records_groups_audio_records
CROSS JOIN audio_records_groups )
ON  vras_audio_records.vras_id = audio_records_groups_vras.vras_id 
AND vras_audio_records.audio_record_id = audio_records_groups_audio_records.audio_record_id 
AND audio_records_groups_vras.audio_records_group_id = audio_records_groups_audio_records.audio_records_group_id
AND audio_records_groups_vras.audio_records_group_id = audio_records_groups.id
 
 
WHERE  audio_records_groups.id IS NULL

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

Manfred Koizar <mkoi-pg@aon.at> writes:
> 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:

BTW, a lot of people coming from MySQL get this wrong.  According to
what I've heard, MySQL considers JOIN to have the same precedence as
comma, so that the above would in fact work as the OP seems to expect.
However, MySQL is flatly in violation of the SQL standard on this
point :-(

            regards, tom lane