View: dbo.Contact_Email_View
View definition
create view dbo.Contact_Email_View
as
select
contact_email_KEY = CTE.contact_email_KEY
, contact_KEY = CTE.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_email_type_KEY = CTE.contact_email_type_KEY
, contact_email_type__description = CTET.description
, email = CTE.email
from
dbo.Contact_Email CTE
left outer join
dbo.Contact CT on CT.contact_KEY = CTE.contact_KEY
left outer join
dbo.Contact_Email_Type CTET on CTET.contact_email_type_KEY = CTE.contact_email_type_KEY