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]

Reply via email to