View: dbo.Filter_Range_Type_View
View definition
create view dbo.Filter_Range_Type_View
as
select
filter_range_type_KEY = FRT.filter_range_type_KEY
, filter_line_type_KEY = FRT.filter_line_type_KEY
, filter_line_type__description = FLT.description
, filter_line_type__subfilter__filter_type_KEY = FLT.subfilter__filter_type_KEY
, description = FRT.description
, lookup_display_member = FRT.lookup_display_member
, update__staff_KEY = FRT.update__staff_KEY
, update__staff__staff_id = S.staff_id
, update_date = FRT.update_date
from
dbo.Filter_Range_Type FRT
left outer join
dbo.Filter_Line_Type FLT on FLT.filter_line_type_KEY = FRT.filter_line_type_KEY
left outer join
dbo.Staff S on S.staff_KEY = FRT.update__staff_KEY