View: dbo.Contact_View
View definition
create view dbo.Contact_View
as
select
contact_KEY = CT.contact_KEY
, name = CT.name
, company = CT.company
, title = CT.title
, salutation = CT.salutation
, url = CT.url
, phone_position = CT.phone_position
, address_position = CT.address_position
, email_position = CT.email_position
, primary__contact_phone_type_KEY = CT.primary__contact_phone_type_KEY
, primary__contact_address_type_KEY = CT.primary__contact_address_type_KEY
, mailing__contact_address_type_KEY = CT.mailing__contact_address_type_KEY
, contact_type_KEY = CT.contact_type_KEY
, contact_type__description = (SELECT description FROM dbo.Contact_Type CTT WHERE CTT.contact_type_KEY = CT.contact_type_KEY)
, file_as = CT.file_as
, contact_guid = CT.contact_guid
, primary__contact_email_type_KEY = CT.primary__contact_email_type_KEY
FROM
dbo.Contact CT