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