View: dbo.Office_View
View definition
create view dbo.Office_View
as
select
office_KEY = O.office_KEY
, office_id = O.office_id
, office_id_sortable = O.office_id_sortable
, description = O.description
, contact_KEY = O.contact_KEY
, contact__primary__contact_phone_type_KEY = CT.primary__contact_phone_type_KEY
, contact__primary__contact_address_type_KEY = CT.primary__contact_address_type_KEY
, contact__mailing__contact_address_type_KEY = CT.mailing__contact_address_type_KEY
, contact__contact_type_KEY = CT.contact_type_KEY
from
dbo.Office O
left outer join
dbo.Contact CT on CT.contact_KEY = O.contact_KEY