View: dbo.Client_Workplace_State_View
View definition
create view dbo.Client_Workplace_State_View
as
select
client_KEY = CL.client_KEY
, state_KEY = LEFT(WL.ste_location_code, 2)
from
dbo.Client CL
inner join
dbo.Client_Primary_Location CPL on CL.client_KEY = CPL.client_KEY
inner join
dbo.Work_Location WL on CPL.location_KEY = WL.location_KEY