>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 >