View: dbo.Custom_Value_Vendor_View
View definition
CREATE VIEW dbo.Custom_Value_Vendor_View
AS
SELECT
custom_value_KEY = CVX.custom_value_KEY
, vendor_KEY = CVX.vendor_KEY
, text = CV.custom_value
, custom_field_KEY = CV.custom_field_KEY
FROM
dbo.Custom_Value_Vendor AS CVX
INNER JOIN
dbo.Custom_Value AS CV
ON
CV.custom_value_KEY = CVX.custom_value_KEY