View: dbo.Custom_Value_Client_View
View definition
CREATE VIEW dbo.Custom_Value_Client_View
AS
SELECT
custom_value_KEY = CVC.custom_value_KEY
, client_KEY = CVC.client_KEY
, text = CV.custom_value
, custom_field_KEY = CV.custom_field_KEY
FROM
dbo.Custom_Value_Client AS CVC
INNER JOIN
dbo.Custom_Value AS CV
ON
CV.custom_value_KEY = CVC.custom_value_KEY