17,137
社区成员
发帖
与我相关
我的任务
分享请教一个简单的SQL语句。多谢！
一直用的SQL SERVER，最近要做一个项目用到ORACLE，碰到1个SQL语句不会写，MarInH为主表，MarInD表为明细表，就是把MarInD中的FQty汇总，更新到MarInH表的FQty字段，
SQL SERVER的写法如下，请问这种语句ORACLE语法应该怎么写？ 非常感谢!
Update H Set H.FQty = D.FQty From MarInH H
Left Join(
Select FNo, Sum(FQty) AS FQty From MarInD
Group by FNo
) D on H.FNo = D.FNo;
SQL SERVER的写法如下，请问这种语句ORACLE语法应该怎么写？ 非常感谢!
Update H Set H.FQty = D.FQty From MarInH H
Left Join(
Select FNo, Sum(FQty) AS FQty From MarInD
Group by FNo
) D on H.FNo = D.FNo;
...全文
请发表友善的回复…
发表回复
wyqxrj 2020-12-23
- 打赏
- 举报
拿走不谢
UPDATE MARINH H
SET H.FQTY =
(SELECT SUM(FQTY)
FROM MARIND D
WHERE H.FNO = D.FNO
GROUP BY FNO)
WHERE EXISTS (SELECT 1 FROM MARIND WHERE H.FNO = D.FNO);
UPDATE MARINH H
SET H.FQTY =
(SELECT SUM(FQTY)
FROM MARIND D
WHERE H.FNO = D.FNO
GROUP BY FNO)
WHERE EXISTS (SELECT 1 FROM MARIND WHERE H.FNO = D.FNO);
