DELETE FROM EMP
WHERE
 EMP.EMP_CODE IN
 (SELECT
   A.EMP_CODE
  FROM
   EMP A 
  LEFT OUTER JOIN EMP_INVALID B
  ON A.EMP_CODE = B.EMP_CODE
  WHERE A.VALID_FLG = '0' AND B.EMP_CODE IS NOT NULL);