View: dbo.Employee_Other_State_Setting_View | |||
View definition | |||
CREATE VIEW dbo.Employee_Other_State_Setting_View AS SELECT Employee_Other_State_Setting.employee_other_state_setting_KEY, Employee_Other_State_Setting.employee_KEY, Employee_Other_State_Setting.employee_other_state_setting_type_KEY, Employee_Other_State_Setting.occupational_title, Employee_Other_State_Setting.geographic_location, Employee_Other_State_Setting.soc_code, (SELECT employee_other_state_setting_type_group_KEY FROM Employee_Other_State_Setting_Type WHERE Employee_Other_State_Setting.employee_other_state_setting_type_KEY = Employee_Other_State_Setting_Type.employee_other_state_setting_type_KEY) AS group_key FROM Employee_Other_State_Setting; | |||