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