DELETE
FROM
    EMP
WHERE
    EMP_CODE IN (
        SELECT
            EMP_CODE
        FROM
            EMP_INVALID
    )
;