View: dbo.Active_Filter_View | |||
View definition | |||
CREATE VIEW dbo.Active_Filter_View AS SELECT active_filter_KEY = AF.active_filter_KEY , staff_KEY = AF.staff_KEY , staff__staff_id = S1.staff_id , staff__staff_status_KEY = S1.staff_status_KEY , staff__office_KEY = S1.office_KEY , staff__supervisor__staff_KEY = S1.supervisor__staff_KEY , staff__contact_KEY = S1.contact_KEY , filter_KEY = AF.filter_KEY , filter__description = F.description , filter__filter_type_KEY = F.filter_type_KEY , filter__filter_type__list_name = FT.list_name , description = AF.description FROM dbo.Active_Filter AF INNER JOIN dbo.Staff AS S1 ON S1.staff_KEY = AF.staff_KEY JOIN dbo.Filter AS F ON F.filter_KEY = AF.filter_KEY JOIN dbo.Filter_Type AS FT ON FT.filter_type_KEY = F.filter_type_KEY | |||