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:13 PM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Howto make a double LEFT JOIN > Remove the parentheses > SELECT table1.id FROM table1 LEFT JOIN table2 LEFT JOIN table3 ON > table2.id=table3.id ON table1.id=table2.id I still got: MySQL retourneerde: You have an error in your SQL syntax near 'LEFT JOIN table3 ON table2.id=table3.id ON table1.id=table2.id' at line 1 -- 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]