DELETE
FROM
    EMP
WHERE
    EMP_CODE IN(
        SELECT
            EMP_CODE
        FROM
            EMP_INVALID
    )
AND VALID_FLG = 0
;