delete
from
    EMP
where
    VALID_FLG = 0
and
    EMP_CODE in (
    select
        e.EMP_CODE
    from
        EMP as e
    join
        EMP_INVALID as i on e.EMP_CODE = i.EMP_CODE
    )