SQLUSA

Microsoft SQL Server 2000

Best Practices

 

How to construct a four table SELECT?

 

Following is an example for a 4-table join:

USE NorthWind

SELECT e.FirstName+' '+e.LastName,
TerritoryDescription, RegionDescription
FROM
Employees e
JOIN EmployeeTerritories et ON e.employeeid = et.employeeid
JOIN Territories t ON et.territoryid = t.territoryid
JOIN Region r ON t.regionid = r.regionid
ORDER BY TerritoryDescription, RegionDescription

 

 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page