delete FROM EMP
 WHERE EMP_CODE IN (
select E.EMP_CODE 
  from EMP E INNER JOIN EMP_INVALID INV ON E.EMP_CODE=INV.EMP_CODE
 where E.VALID_FLG<>1
);
select * from EMP;