View: dbo.Contact_Phone_View
View definition
create view dbo.Contact_Phone_View
as
select
contact_phone_KEY = CTP.contact_phone_KEY
, contact_KEY = CTP.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
, contact_phone_type_KEY = CTP.contact_phone_type_KEY
, contact_phone_type__description = CTPT.description
, phone = CTP.phone
, extension = CTP.extension
from
dbo.Contact_Phone CTP
left outer join
dbo.Contact CT on CT.contact_KEY = CTP.contact_KEY
left outer join
dbo.Contact_Phone_Type CTPT on CTPT.contact_phone_type_KEY = CTP.contact_phone_type_KEY