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

select * 
from EMP;