View: dbo.Custom_Grouping_View
View definition
create view dbo.Custom_Grouping_View
as
select
custom_grouping_KEY = CG.custom_grouping_KEY
, custom_field_KEY = CG.custom_field_KEY
, custom_field__description = CF.description
, custom_field__custom_field_type_KEY = CF.custom_field_type_KEY
, custom_grouping_id = CG.custom_grouping_id
, custom_grouping_id_sortable = CG.custom_grouping_id_sortable
, description = CG.description
from
dbo.Custom_Grouping CG
left outer join
dbo.Custom_Field CF on CF.custom_field_KEY = CG.custom_field_KEY