I am not certain if I set this up correctly - all help would be appreciated:
SELECT [MASTER EOG].ACCOUNTID, [MASTER EOG].PUBCODE, [MASTER EOG].NAME, [MASTER EOG].PIATYPE, [MASTER EOG].FOD, [MASTER EOG].SUBSLNGTH, [MASTER EOG].RATECODE, [MASTER EOG].CURRENTBAL, [MASTER EOG].EOGDATE, [MASTER EOG].TELEPHONE, [MASTER EOG].ASSIGNDATE
FROM [MASTER EOG] As t1 LEFT JOIN [CLC REPORTS] As t2
ON t1.ACCOUNTID = t2.ACCOUNTID, ON t1.PUBCODE = t2.PubCode, ON t1.NAME = t2.Name, ON t1.RATECODE = t2.RateCode, ON t1.EOGDATE = t2.EOGDate, ON t1.TELEPHONE = t2.Telephone