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