View: dbo.Practice_User_View | |||
View definition | |||
create view dbo.Practice_User_View as select practice_user_KEY = PU.practice_user_KEY , update__staff_KEY = PU.update__staff_KEY , update__staff__staff_id = S.staff_id , update_date = PU.update_date , staff_KEY = PU.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 , salt = PU.salt , password_hash = PU.password_hash , must_change_password = PU.must_change_password from dbo.Practice_User PU left outer join dbo.Staff S on S.staff_KEY = PU.update__staff_KEY left outer join dbo.Staff S1 on S1.staff_KEY = PU.staff_KEY | |||