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