delete
from EMP
where
    EMP_CODE in (
        select
            ei.EMP_CODE
        from
            EMP_INVALID as ei
        inner join
            EMP as e
            on ei.EMP_CODE = e.EMP_CODE
        where
            e.VALID_FLG != '1'
    )