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