Hello All,
I have a LEFT JOIN nested inside an INNER JOIN that generates a mySQL
syntax error. I'm new to mySQL so I wonder if anyone could help me
understand the problem. The query runs fine under PostgreSQL, MS SQL, and
MS Access.
SELECT
Recording.Entry, InstCode.InstType, Recording.DateRec
FROM
InstCode INNER JOIN
(Recording LEFT JOIN Legal ON Recording.Entry = Legal.Entry)
ON InstCode.InstCode = Recording.InstCode
WHERE
Legal.PIDN = '22-41-17-26-2-00-005';
Thanks,
Rich
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
