by 손님 [2008.10.23 17:58:04]
MERGE INTO RECEIVE_MONTH MON
USING (SELECT * FROM RECEIVE_MONTH WHERE MEMBER_ID = ?
AND ITEM_CD = ? AND REQ_YM = ?) S_MON
ON(S_MON.MEMBER_ID = MON.MEMBER_ID)
WHEN MATCHED THEN
UPDATE SET RECEIVE_AMT = ?
WHEN NOT MATCHED THEN
INSERT (MEMBER_ID , ITEM_CD , REQ_YM, RECEIVE_DT, RECEIVE_AMT, CONTAC_TEACHER_BE_CD,
CONTAC_TEACHER, RCPT_TEACHER_BE_CD, RCPT_TEACHER, FIR_RCPT_TEACHER)
VALUES ( ?,?,?,?,?,?,?,?,?,?) ;
-------------------------------------------------------------------------------------------------------------------------------------------
쿼리를 돌리면 되지가 않아요..ㅠㅠ
웹상에서 뿌리면 UPDATE는 되는데 INSERT가 안됩니다..
이유가 뭘까요..?
아시는분 도움 좀 주세요.