SQL Query – GoldMine Primary Contacts with Primary Email, and Email Merge Code

The following SQL Query will display all of the GoldMine Primary Contacts with their associated Primary Email Address, as well as the Email Merge Code.

 

select contact1.contact, isnull(contsupp.contsupref,”) + isnull(contsupp.address1,”) as Email, contsupp.mergecodes
from contact1
left outer join contsupp on contact1.accountno=contsupp.accountno
where contsupp.rectype=’P’ and contsupp.contact=’E-Mail Address’ and contsupp.zip like ‘_1%’