View: dbo.Work_Location_View
View definition
-- add a view for the Work_Location table, also include the client_KEY and description from the related Location
CREATE VIEW
dbo.Work_Location_View
AS
SELECT
WL.work_location_KEY,
WL.ste_location_code,
WL.location_KEY,
WL.contact_address_type_KEY,
WL.work_location_guid,
WL.reporting_unit,
-- include the related Location client_KEY and description
L.client_KEY as client_KEY,
L.description,
L.description as location__description
FROM
dbo.Work_Location as WL
-- join the related Location
JOIN
dbo.Location as L
ON
WL.location_KEY = L.location_KEY