View: dbo.Filter_Range_View | |||
View definition | |||
create view dbo.Filter_Range_View as select filter_range_KEY = FR.filter_range_KEY , update__staff_KEY = FR.update__staff_KEY , update__staff__staff_id = S.staff_id , update_date = FR.update_date , filter_base_type_KEY = FR.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 , filter_range_type_KEY = FR.filter_range_type_KEY , filter_range_type__description = FRT.description , filter_range_type__filter_line_type_KEY = FRT.filter_line_type_KEY , from_value = FR.from_value , to_value = FR.to_value , last_refreshed = FR.last_refreshed from dbo.Filter_Range FR left outer join dbo.Staff S on S.staff_KEY = FR.update__staff_KEY left outer join dbo.Filter_Base_Type FBT on FBT.filter_base_type_KEY = FR.filter_base_type_KEY left outer join dbo.Filter_Range_Type FRT on FRT.filter_range_type_KEY = FR.filter_range_type_KEY | |||