On Wed, 28 Apr 2004 12:33:15 +0300, "Bogdan Vatkov"
<[EMAIL PROTECTED]> 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
