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