View: dbo.Filter_Select_View
View definition
create view dbo.Filter_Select_View
as
select
filter_select_KEY = FS.filter_select_KEY
, update__staff_KEY = FS.update__staff_KEY
, update__staff__staff_id = S.staff_id
, update_date = FS.update_date
, filter_line_KEY = FS.filter_line_KEY
, filter_line__filter_KEY = FL.filter_KEY
, filter_line__filter_base_type_KEY = FL.filter_base_type_KEY
, filter_line__subfilter__filter_KEY = FL.subfilter__filter_KEY
, filter_line__filter_range_type_KEY = FL.filter_range_type_KEY
, selected = FS.selected
from
dbo.Filter_Select FS
left outer join
dbo.Staff S on S.staff_KEY = FS.update__staff_KEY
left outer join
dbo.Filter_Line FL on FL.filter_line_KEY = FS.filter_line_KEY