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