View: dbo.Custom_Fieldview_View
View definition
create view dbo.Custom_Fieldview_View
as
select
custom_fieldview_KEY = CFV.custom_fieldview_KEY
, custom_fieldview_type_KEY = CFV.custom_fieldview_type_KEY
, custom_fieldview_type__description = CFVT.description
, description = CFV.description
from
dbo.Custom_Fieldview CFV
left outer join
dbo.Custom_Fieldview_Type CFVT on CFVT.custom_fieldview_type_KEY = CFV.custom_fieldview_type_KEY