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