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;