JOIN three table

Question

hello; how I Join three tabble wiyh sql querry

Niradhip Chakraborty · Answer

The name of my three tables are Customer_Details  EMAS  work_orders. The query is as follows: SELECT Distinct * from Customer_Details Left Outer join EMAS on Customer_Details.street_name = EMAS.street_name Left Outer join work_orders on Customer_Details.ID = work_orders.customer_ID where Proceed_Retrofit = 'yes' You also can check the folowing article: 1. http://msdn.microsoft.com/en-us/library/ms191430.aspx