View: dbo.Filter_Type_View
View definition
create view dbo.Filter_Type_View
as
select
filter_type_KEY = FT.filter_type_KEY
, list_name = FT.list_name
, update__staff_KEY = FT.update__staff_KEY
, update__staff__staff_id = S.staff_id
, update_date = FT.update_date
, description = FT.description
from
dbo.Filter_Type FT
left outer join
dbo.Staff S on S.staff_KEY = FT.update__staff_KEY