Remove the parentheses SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT JOIN table3 ON table2.id=table3.id
-----Original Message----- From: Bas Jobsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 3:00 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Howto make a double LEFT JOIN Hello, How can i make a double LEFT JOIN? Now i have got: SELECT table1.id FROM table1 LEFT JOIN (table2 LEFT JOIN table3 ON table2.id=table3.id) ON table1.id=table2.id but this gives an error Tnx, Bas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
