Re: Howto make a double LEFT JOIN
| From: | Bas Jobsen | Date: | Tue, 02 Oct 2001 20:13:01 +0000 |
| Subject: | Re: Howto make a double LEFT JOIN | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12935@lists.php.net to get a copy of this message | ||
> 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