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