SELECT a.*,; SUM(IIF(b.acct_id = 0, 1, 0)) cntZERO,; SUM(IIF(b.acct_id = 0, b.econ, 0.00)) econZERO,; SUM(IIF(b.acct_id = 0, b.emat, 0.00)) ematZERO,; SUM(IIF(b.acct_id = 0, b.nProfits, 0.00)) PSZERO,; SUM(IIF(b.acct_id <> 0, 1, 0)) cntOTHER,; SUM(IIF(b.acct_id <> 0, b.econ, 0.00)) econOTHER,; SUM(IIF(b.acct_id <> 0, b.emat, 0.00)) ematOTHER,; SUM(IIF(b.acct_id <> 0, b.nProfits, 0.00)) PSOTHER; FROM temp1 AS a, acctcont AS b; WHERE a.invnum = b.invnum AND a.contrib_dt = b.contrib_dt AND b.transtype = 'T'; GROUP BY a.invnum, a.contrib_dt; HAVING ; ABS(econZERO) = ABS(econOTHER) AND ; ABS(ematZERO) = ABS(ematOTHER) AND ; ABS(PSZERO) = ABS(PSOTHER) ; AND cntZERO = cntOTHER; INTO TABLE temp