DELETE
FROM 
    EMP AS e
WHERE
    e.EMP_CODE IN (
        SELECT
            ev.EMP_CODE
        FROM
            EMP_INVALID AS ev
    )
    AND VALID_FLG <> 1
;