FROM table1
LEFT JOIN table2 ON table1.column = table2.column
LEFT JOIN table3 ON table1.column = table3.column
-Original Message-
From: Krasimir_Slaveykov [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 16:07
To: [EMAIL PROTECTED]
Subject: 2 or more LEFT JOIN?
Hello mysql,
If I
Sure you can do that.
SELECT * FROM Tab1
LEFT JOIN Tab2 ON Tab1.field1=Tab2.field1
LEFT JOIN Tab3 ON Tab1.field1=Tab3.field1
LEFT JOIN Tab4 ON ...
You can mix and match many different joins on many tables. The only
problem you really run into is complexity. You could even do something
like this:
