SQLD · 제62회 · 12번

MERGE INTO T1 A
USING T2 B
   ON (A.NUM = B.NUM)
WHEN MATCHED THEN
   UPDATE SET A.TOTAL_PAY = A.SALARY + B.COMM
   DELETE WHERE A.TOTAL_PAY < 4000
WHEN NOT MATCHED THEN
   INSERT (NUM, SALARY, TOTAL_PAY)
   VALUES (B.NUM, 3000, 3000);