View: dbo.Filter_Line_Type_View
View definition
create view dbo.Filter_Line_Type_View
as
select
filter_line_type_KEY = FLT.filter_line_type_KEY
, description = FLT.description
, lookup_list_name = FLT.lookup_list_name
, lookup_value_member = FLT.lookup_value_member
, subfilter__filter_type_KEY = FLT.subfilter__filter_type_KEY
, update__staff_KEY = FLT.update__staff_KEY
, update__staff__staff_id = S.staff_id
, update_date = FLT.update_date
from
dbo.Filter_Line_Type FLT
left outer join
dbo.Filter_Type FT on FT.filter_type_KEY = FLT.subfilter__filter_type_KEY
left outer join
dbo.Staff S on S.staff_KEY = FLT.update__staff_KEY