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