DELETE FROM
EMP 
WHERE EMP_CODE IN (
 SELECT E1.EMP_CODE
 FROM
 EMP AS E1
,EMP_INVALID AS E2
 WHERE
  E1.EMP_CODE = E2.EMP_CODE
  AND E1.VALID_FLG !='1'
 )
;