| 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 |
|
|
|