DELETE FROM ADSUM INSERT INTO ADSUM (CO_CD,DIV_CD,FILL_DT,ACCT_CD,DRCR_FG,ACCT_AM) SELECT A.CO_CD,A.DIV_CD,A.ISU_DT,A.ACCT_CD,A.DRCR_FG,SUM(A.ACCT_AM) FROM (SELECT A.CO_CD,A.DIV_CD,A.ISU_DT,A.DRCR_FG,A.ACCT_CD,A.ACCT_AM FROM ADOCUD A INNER JOIN ADOCUH B ON A.CO_CD = B.CO_CD AND A.ISU_DT = B.ISU_DT AND A.ISU_SQ = B.ISU_SQ AND A.DIV_CD = B.DIV_CD WHERE B.FILL_DT > '00000000' ) A GROUP BY A.CO_CD,A.DIV_CD,A.ISU_DT,A.ACCT_CD,A.DRCR_FG