更新联接时出错

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

我收到此错误

这是我当前的错误: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 (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'