Joining 3 or more Tables in SQL Server

Joining 3 or more Tables in SQL Server

Here is a sample SQL Query which would let you join Three or more Tables and display data from them using simple Select Statement:

SELECT p.Name, v.Name

FROM Production.Product p

JOIN Purchasing.ProductVendor pv

ON p.ProductID = pv.ProductID

JOIN Purchasing.Vendor v

ON pv.BusinessEntityID = v.BusinessEntityID

WHERE ProductSubcategoryID = 15

ORDER BY v.Name;

Modify the field names and Table Names according to your requirement...