SELECT Company,ac.contact AS 'Additional Contact', COALESCE(em.contsupref, '')+COALESCE(em.address1, '') AS 'Email Address',  ac.phone, em.mergecodes
FROM contact1
JOIN contsupp ac on contact1.accountno=ac.accountno
JOIN contsupp em on ac.recid=em.linkacct
WHERE ac.rectype='c' AND em.contact='E-Mail Address' AND (em.linkacct NOT LIKE '' AND em.linkacct IS NOT NULL) AND em.zip LIKE '_0%'