INSERT INTO tAcctCont ; (; iTransact, ; transtype, ; Acct_ID, ; econ, ; emat, ; nprofits, ; erforfeit, ; vesteddist, ; othforfeit, ; nprofitsvd, ; totdistrib, ; ibucketid, ; planid, ; empid, ; contrib_dt ; ) ; SELECT ; iTransact, ; transtype, ; Acct_ID, ; SUM(econ) AS econ, ; SUM(emat) AS emat, ; SUM(nprofits) AS nprofits, ; SUM(erforfeit) AS erforfeit, ; SUM(vesteddist) AS vesteddist, ; SUM(othforfeit) AS othforfeit, ; SUM(nprofitsvd) AS nprofitsvd, ; SUM(totdistrib) AS totdistrib, ; ibucketid, ; planid, ; empid, ; contrib_dt ; FROM tAcctContTEMP ; GROUP BY 1, 3