View: dbo.Filter_Line_View
View definition
create view dbo.Filter_Line_View
as
select
filter_line_KEY = FL.filter_line_KEY
, update__staff_KEY = FL.update__staff_KEY
, update__staff__staff_id = S.staff_id
, update_date = FL.update_date
, filter_KEY = FL.filter_KEY
, filter__description = F.description
, filter__filter_type_KEY = F.filter_type_KEY
, filter_base_type_KEY = FL.filter_base_type_KEY
, filter_base_type__description = FBT.description
, filter_base_type__filter_type_KEY = FBT.filter_type_KEY
, filter_base_type__filter_line_type_KEY = FBT.filter_line_type_KEY
, is_method_all = FL.is_method_all
, subfilter__filter_KEY = FL.subfilter__filter_KEY
, subfilter__filter__description = F1.description
, subfilter__filter__filter_type_KEY = F1.filter_type_KEY
, filter_range_type_KEY = FL.filter_range_type_KEY
, filter_range_type__description = FRT.description
, filter_range_type__filter_line_type_KEY = FRT.filter_line_type_KEY
, from_value = FL.from_value
, to_value = FL.to_value
from
dbo.Filter_Line FL
left outer join
dbo.Staff S on S.staff_KEY = FL.update__staff_KEY
left outer join
dbo.Filter F on F.filter_KEY = FL.filter_KEY
left outer join
dbo.Filter_Base_Type FBT on FBT.filter_base_type_KEY = FL.filter_base_type_KEY
left outer join
dbo.Filter F1 on F1.filter_KEY = FL.subfilter__filter_KEY
left outer join
dbo.Filter_Range_Type FRT on FRT.filter_range_type_KEY = FL.filter_range_type_KEY