View: dbo.Staff_Security_Group_View
View definition
create view dbo.Staff_Security_Group_View
as
select
staff_security_group_KEY = SSG.staff_security_group_KEY
, staff_KEY = SSG.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
, security_group_KEY = SSG.security_group_KEY
, security_group__description = SG.description
from
dbo.Staff_Security_Group SSG
left outer join
dbo.Staff S1 on S1.staff_KEY = SSG.staff_KEY
left outer join
dbo.Security_Group SG on SG.security_group_KEY = SSG.security_group_KEY