delete from EMP
where EMP_CODE in (
    select EMP.EMP_CODE
    from EMP_INVALID
    join EMP 
    on EMP_INVALID.EMP_CODE = EMP.EMP_CODE
    where EMP.VALID_FLG = 0
);