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
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 |