FROM table1
LEFT JOIN table2 ON table1.column = table2.column
LEFT JOIN table3 ON table1.column = table3.column
-----Original Message-----
From: Krasimir_Slaveykov [mailto:krasi@stripped]
Sent: donderdag 10 juli 2003 16:07
To: mysql@stripped
Subject: 2 or more LEFT JOIN?
Hello mysql,
If I have one main table - Tab1 and 2 or more tables wich are related
with Tab1, but Tab2 possibly will have records for each in Tab1 ot
possibly not. Tab3-too.
So I need to join Tab1 with Tab2 with LEFT JOIN and Tab1 with Tab3 -
with LEFT JOIN too.
Is that possible? ... and if YES ... how to write in SQL statement?
Thanks.
--
Best regards,
Krasimir_Slaveykov mailto:krasi@stripped
sysadmin@stripped
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
