다른 테이블과 JOIN하여 DELETE하기

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 = ?
     )