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 | |||