View: dbo.Filter_View
View definition
create view dbo.Filter_View
as
select
filter_KEY = F.filter_KEY
, update__staff_KEY = F.update__staff_KEY
, update__staff__staff_id = S.staff_id
, update_date = F.update_date
, filter_type_KEY = F.filter_type_KEY
, description = F.description
, match_all = F.match_all
from
dbo.Filter F
left outer join
dbo.Staff S on S.staff_KEY = F.update__staff_KEY
left outer join
dbo.Filter_Type FT on FT.filter_type_KEY = F.filter_type_KEY