View: dbo.Contact_Address_View | |||
View definition | |||
create view dbo.Contact_Address_View as select contact_address_KEY = CTA.contact_address_KEY , contact_KEY = CTA.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_address_type_KEY = CTA.contact_address_type_KEY , contact_address_type__description = CTAT.description , address_1 = CTA.address_1 , address_2 = CTA.address_2 , city = CTA.city , state_abbreviation = CTA.state_abbreviation , postal_code = CTA.postal_code , county = CTA.county , country = CTA.country , location_search_accuracy_type_KEY = CTA.location_search_accuracy_type_KEY , lcs_normalized_address = CTA.lcs_normalized_address , latitude = CTA.latitude , longitude = CTA.longitude from dbo.Contact_Address CTA left outer join dbo.Contact CT on CT.contact_KEY = CTA.contact_KEY left outer join dbo.Contact_Address_Type CTAT on CTAT.contact_address_type_KEY = CTA.contact_address_type_KEY | |||