看看这个怎么写update?

[aska_xxy]

两个表
A
id qty
B
id qty

要把AB中ID 相等行上的qty加到B上，即

B.qty =B.qty +A.qty

[CodeMagic]

update b set qty=nvl((select a.qty+b.qty from a where a.id=b.id),b.qty);

[dinya2003]

update testc c set c.name=c.name+(select a.name from testa a where a.id=c.id)

[dinya2003]

不好意思,用了我自己的测试表

update b set b.qty=b.qty+(select a.qty from a where a.id=b.id)

[caral525]

UPDATE B b
SET b.qty=b.qty+(SELECT a.qty FROM A a WHERE a.id=b.id);

[caral525]

郁闷，为什么我发贴前看不到有人贴了答案呢，急！又没分分挣了

[ljxsea]

UDATE B SET B.qty=B.qty+NVL((SELECT A.qty FROM A WHERE A.id=B.id),0) WHERE B.id=A.ID

[WilliamXiaoLiang]

update
b
set
b.qty=b.qty+(select a.qty from a where a.id=b.id);

1 ROW UPDATE

顶一下！
QQ:390958177
Email:[e-mail]

[aska_xxy]

问题追加：

首先肯定一楼写的应该是正确的，
类似 b.qty=b.qty+(SELECT a.qty FROM A a WHERE a.id=b.id)应该会报错吧？

问题，如果要在A上锁定范围a.id between 1 and 100，而在更新B的时候
我也只想更新b.id between 1 and 100的是数据，而不是整个B表，
请问是否有解呢？

[zwj0712]

update b set b.qty=b.qty+(select a.qty from a where a.id=b.id) where b.id between 1 and 100

[dinya2003]

update b set b.qty=b.qty+(select a.qty from a where a.id=b.id )where b.id between 1 and 100

[CodeMagic]

update b set qty=nvl((select a.qty+b.qty from a where a.id=b.id),b.qty) where b.id between 1 and 100;