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