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