EMPLOYEE TERRIRORIES

CREATE VIEW [dbo].[vEmployeeTerritories]

AS

SELECT EmployeeTerritories.*, Employees.LastName + ', ' + Employees.FirstName as Employee,

Territories.TerritoryDescription AS Territory

FROM EmployeeTerritories

INNER JOIN Employees ON Employees.EmployeeID = EmployeeTerritories.EmployeeID

INNER JOIN Territories ON Territories.TerritoryID = EmployeeTerritories.TerritoryID

GO

We use the vEmployeeTerritories below to grab the Employee FullName and TerritoryDescription