View: dbo.Staff_Locator_View | |||
View definition | |||
create view dbo.Staff_Locator_View as select staff_locator_KEY = SLO.staff_locator_KEY , staff_KEY = SLO.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 , staff_locator_status_KEY = SLO.staff_locator_status_KEY , staff_locator_status__description = SLOS.description , returning = SLO.returning , comments = coalesce(SLO.comments, N'') from dbo.Staff_Locator SLO left outer join dbo.Staff S1 on S1.staff_KEY = SLO.staff_KEY left outer join dbo.Staff_Locator_Status SLOS on SLOS.staff_locator_status_KEY = SLO.staff_locator_status_KEY | |||