DELETE
  FROM TABLE_CD A
 WHERE EXISTS (
       SELECT '1'
         FROM TABLE_CD_HISTORY
        WHERE ID_SEQ = A.ID_SEQ
          AND MEM_ID = A.MEM_ID
          AND SUPP_ID = ?
     ) 

Posted by 준콩ol 준콩ol

댓글을 달아 주세요