delete from EMP 
where
  VALID_FLG = '0' and
  exists(
    select 1 from EMP_INVALID b
    where
      EMP_CODE = b.EMP_CODE and
      EMP_LAST_NAME = b.EMP_LAST_NAME and
      EMP_FIRST_NAME = b.EMP_FIRST_NAME and
      EMP_KANA_NAME = b.EMP_KANA_NAME and
      EMP_ENG_NAME = b.EMP_ENG_NAME and
      EMAIL_ACCOUNT = b.EMAIL_ACCOUNT and
      DEPT_CODE = b.DEPT_CODE and
      b.VALID_FLG = '0' and
      UPDATE_USER_NAME = b.UPDATE_USER_NAME
  )