View: dbo.Filter_Range_Cache_View | |||
View definition | |||
create view dbo.Filter_Range_Cache_View as select filter_range_cache_KEY = FRC.filter_range_cache_KEY , update__staff_KEY = FRC.update__staff_KEY , update__staff__staff_id = S.staff_id , update_date = FRC.update_date , filter_range_KEY = FRC.filter_range_KEY , filter_range__filter_base_type_KEY = FR.filter_base_type_KEY , filter_range__filter_range_type_KEY = FR.filter_range_type_KEY , selected = FRC.selected from dbo.Filter_Range_Cache FRC left outer join dbo.Staff S on S.staff_KEY = FRC.update__staff_KEY left outer join dbo.Filter_Range FR on FR.filter_range_KEY = FRC.filter_range_KEY | |||