View: dbo.Custom_Value_Employee_View | |||
View definition | |||
CREATE VIEW dbo.Custom_Value_Employee_View AS SELECT custom_value_KEY = CVX.custom_value_KEY , employee_KEY = CVX.employee_KEY , text = CV.custom_value , custom_field_KEY = CV.custom_field_KEY FROM dbo.Custom_Value_Employee AS CVX INNER JOIN dbo.Custom_Value AS CV ON CV.custom_value_KEY = CVX.custom_value_KEY | |||