DELETE 
FROM EMP AS E
 INNER JOIN EMP_INVALID AS EMPIN
  ON E.EMP_CODE = EMPIN.EMP_CODE
  
WHERE
 E.EMP_CODE = EMPIN.EMP_CODE AND
 E.VALID_FLG = '1';