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