View: dbo.Custom_Value_Staff_View
View definition
CREATE VIEW dbo.Custom_Value_Staff_View
AS
SELECT
custom_value_KEY = CVX.custom_value_KEY
, staff_KEY = CVX.staff_KEY
, text = CV.custom_value
, custom_field_KEY = CV.custom_field_KEY
FROM
dbo.Custom_Value_Staff AS CVX
INNER JOIN
dbo.Custom_Value AS CV
ON
CV.custom_value_KEY = CVX.custom_value_KEY