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