-- EMPのvalid_flgが０かつEMP_INVALIDにあるやつを消す
DELETE
FROM EMP
WHERE VALID_FLG = 0 AND
EMP_CODE IN(
SELECT EMP_CODE FROM EMP_INVALID
);