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