select contact1.company, contsupp.address2, 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’
SQL Query – ALL GoldMine Email Addresses (Primary and Additional)
