delete from EMP
where exists(
    select * 
    from EMP e
    inner join EMP_INVALID i
    on e.EMP_CODE = i.EMP_CODE
    and VALID_FLG != '1'
);