BUG ? or SQL miss understanding ?

From: "Bogdan Vatkov" <bvatkov(at)globaltech-bg(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: BUG ? or SQL miss understanding ?
Date: 2004-04-28 09:33:15
Message-ID: 045e01c42d03$d4eb78d0$690ba8c0@int.globaltechbg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manfred Koizar 2004-04-28 09:34:44 Re: Updates not atomic with respect to indexes
Previous Message Ben Pettman 2004-04-28 09:31:18 Pop 3 Emails to Postgresql