GoldMine SQL I need a Query
Posted on 2004-08-24
I need a query that will pull related information from three tables.
The Contsupp, Contact1, Contact2
The query is supposed to get me the fields indicated with those primary contact records with email addresses with hose that have comments indicated.
Here is my query but I do not think I am getting it right as it is pulling too much data, do I need to make a join?
CS2.Contsupref+CS2.address1 as email from
Contact2, Contact1, Contsupp, contsupp as CS2 where
( (contact2.accountno = contact1.accountno) and (contact1.accountno = contsupp.accountno) and
Comments = 'mailing listA' and
CONTSUPP.RECTYPE = 'P' AND
CONTSUPP.CONTACT = 'E-mail Address'AND
CONTSUPP.ZIP LIKE '01%')