DataDivaJill
MIS
i need a stored procedure to garb info from 3 goldmine tables
first i want all contacts from contact1 table.
then i want all history for those records from the conthist table.
but i also want all pending activity from the calendar table.
they are all linked via gm accountno.
from contact1 table want:
contact1.accountno,contact1.company,contact1.contact
from calendar table i want:
cal.accountno,cal.ondate,cal.userid,cal.rectype
from the history table i want:
conthist.accountno,conthist.ondate,conthist.userid,conthist.rectype
can anyone help me with this??
my goal is to then create a crystal report from all that data.
sam smith , abc company had a pending call on 2/4/2004 and had a history appointment on 1/31/2004
so i want only contacts that have either history or calendar.
jill messier
computer control corp
8605296232
first i want all contacts from contact1 table.
then i want all history for those records from the conthist table.
but i also want all pending activity from the calendar table.
they are all linked via gm accountno.
from contact1 table want:
contact1.accountno,contact1.company,contact1.contact
from calendar table i want:
cal.accountno,cal.ondate,cal.userid,cal.rectype
from the history table i want:
conthist.accountno,conthist.ondate,conthist.userid,conthist.rectype
can anyone help me with this??
my goal is to then create a crystal report from all that data.
sam smith , abc company had a pending call on 2/4/2004 and had a history appointment on 1/31/2004
so i want only contacts that have either history or calendar.
jill messier
computer control corp
8605296232