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