The following is a SQL Query that will display Additional Contacts with their Mailing Address, Email Address and the associated Email Merge Code and Mail Merge Code. select c1.accountno, c1.key1, ac.contact, ac.city, ac.state, ac.mergecodes, em.contsupref, em.mergecodes, substring(em.mergecodes,1,1) as CHECKED from contact1 c1 join contsupp ac on c1.accountno=ac.accountno join contsupp em...
Day: March 1, 2010
GoldMine SQL Query to Find Duplicates Between Primary and Additional Contacts
select contact1.company, contact1.contact from contact1, contsupp where contact1.contact = contsupp.contact and contact1.accountno = contsupp.accountno order by contact1.contact