Table of Contents



pears.contactcompany

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Gives linked Person and Company names for a Contact Event record

Original SQL

COMMENT ON VIEW "pears"."contactcompany" IS 
	'Gives linked Person and Company names for a Contact Event record'
GO
 
COMMENT TO PRESERVE FORMAT ON VIEW "pears"."contactcompany" IS 
{CREATE VIEW contactcompany 
(contacteventid,cpname,cpkeyname,cppersonid,
cname,ckeyname,companyid)
AS SELECT contacteventid,
person."name",person.keyname,employment.personid,
company."name",company.keyname,employment.companyid
 FROM pears.contactevent KEY LEFT OUTER JOIN 
(pears.employment KEY JOIN(pears.company,pears.person))
}