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 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:[EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
