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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
