时间戳

首页 > 解决方案 > JPQL 更新与选择

sql - JPQL 更新与选择

问题描述

我正在尝试将本机查询转换为 JPQL，但我在选择时遇到了 UPDATE 问题。

UPDATE DocumentBody PP SET PP.prepaidLeft = PP.prepaidLeft + (SELECT R.amount 
FROM ReferencePrepaymentDocument R WHERE PP.documentBodyId = 
R.prepaymentDocumentBodyId AND R.documentHeaderId=:NaglDokRozchID) WHERE EXISTS 
(SELECT R.amount FROM ReferencePrepaymentDocument R WHERE PP.documentBodyId = 
R.prepaymentDocumentBodyId AND R.documentHeaderId=:NaglDokRozchID)

我试过这样加入：

UPDATE DocumentBody PP SET PP.prepaidLeft = PP.prepaidLeft + amount JOIN 
(select R.amount from ReferencePrepaymentDocument R where PP.documentBodyId = 
R.prepaymentDocumentBodyId and R.documentHeaderId=:NaglDokRozchID) amount ON 
PP.documentBodyId = R.prepaymentDocumentBodyId  where exists (select R.amount 
from ReferencePrepaymentDocument R where PP.documentBodyId = 
R.prepaymentDocumentBodyId and R.documentHeaderId=:NaglDokRozchID)

但我得到“操作员或预期的地方，得到'JOIN'”。

先感谢您。

标签： sqloraclejpql

解决方案

推荐阅读