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