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