pears.contactperson

Gives names of people linked to Contact Event records

CREATE VIEW "pears"."contactperson"( "contacteventid",
  "pname","pkeyname","ppersonid" ) 
  AS SELECT "contactevent"."contacteventid","person"."name","person"."keyname","person"."personid"
    FROM "pears"."contactevent" KEY LEFT OUTER JOIN "pears"."person"
GO
 
COMMENT ON VIEW "pears"."contactperson" IS 
	'Gives names of people linked to Contact Event records'
GO
 
COMMENT TO PRESERVE FORMAT ON VIEW "pears"."contactperson" IS 
{CREATE VIEW contactperson 
(contacteventid,pname,pkeyname,ppersonid)
AS SELECT contacteventid,"name",keyname,person.personid
FROM pears.contactevent KEY LEFT OUTER JOIN pears.person
}