更新加入时出错

本文介绍了更新加入时出错的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我收到了这个错误

这是我当前的错误:ORA-00971:缺少 SET 关键字

This is my Current error: ORA-00971: missing SET keyword

UPDATE FGMULTI (JOIN arinvt ar
 ON  fgmulti.arinvt_id = ar.id)

 SET NON_CONFORM_ALLOCATABLE = 'Y'

 WHERE IN_Date = CurrentDate
  AND ar.Class LIKE 'CP%'
  (OR ar.Class LIKE 'FG%'
  OR ar.Class LIKE 'IN%'
  OR ar.Class LIKE 'LA%'
  OR ar.Class LIKE 'PK%')

推荐答案

使用 update for select by join

use update for select by join

 UPDATE (select NON_CONFORM_ALLOCTABLE
         from FGMULTI
          JOIN arinvt ar
          ON  fgmulti.arinvt_id = ar.id
         WHERE IN_Date = CurrentDate
         AND ar.Class LIKE 'CP%'
         OR ar.Class LIKE 'FG%'
         OR ar.Class LIKE 'IN%'
         OR ar.Class LIKE 'LA%'
         OR ar.Class LIKE 'PK%') t
 SET t.NON_CONFORM_ALLOCATABLE = 'Y'

这篇关于更新加入时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！