delete from EMP
where EMP_CODE IN 
(select e.EMP_CODE 
from EMP as e inner join EMP_INVALID as ei on e.EMP_CODE = ei.EMP_CODE
where e.VALID_FLG = "0");