-
Notifications
You must be signed in to change notification settings - Fork 18
Open
Description
Ported from CodePlex
SELECT EmpWithTerrs.FirstName,
EmpWithTerrs.LastName,
EmpWithTerrs.TerritoryDescription,
Regs.RegionDescription
FROM (
SELECT e.firstname,
e.lastname,
t.*
FROM Employees e
INNER JOIN EmployeeTerritories et ON et.EmployeeID = e.EmployeeID
RIGHT JOIN Territories t ON t.TerritoryID = et.TerritoryID
) AS EmpWithTerrs
INNER JOIN
(
SELECT *
FROM Region r
) AS Regs ON Regs.RegionId = EmpWithTerrs.RegionId
WHERE EmpWithTerrs.FirstName = 'Robert'
OR EmpWithTerrs.FirstName IS NULL
ORDER BY 2, 1The inner join between regions and territories should be performed before the outer join.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels