这个问题SQL语句怎么写，最好是一句

[menuvb]

表的结构 a
userid username monery
1 menuvb 200
2 aaa 100
3 bbb 300

表B
formID userid monery
1 1 20
2 2 100
3 3 50

现在在表B中，除了userid＝3的记录，按表B中的monery字段值重新更新到表A中。比如
userid=1 更新之后为 monery=220
userid=3 更新之后为 monery=350

想了半天，只想出了循环来更新。但实在太麻烦了，所以想请教下能不能一句话就可以了？

[poonz]

学习

[xiaoxiangqing]

update 表A set monery = monery + b.monery from 表A a join 表B b on a.userid = b.userid
and a.userid <> 3

[hglhyy]

UPDATE a SET monery = b.monery FROM a,b WHERE a.id = b.id AND B.userid<>3

[good2speed]

试试
UPDATE a SET monery = b.monery FROM a,b WHERE a.id = b,id

[menuvb]

不行，实际不了我的结果。我需要除了USERID＝之外，更新A表的所有monery字段值

[子陌红尘]

update 表A set monery = monery + b.monery from 表A a ,表B b where a.userid = b.userid
and a.userid <> 3

[wannianliu]

update a set monery=monery+(select monery from b where userid=a.userid)

[bluebird_1982]

用游标，一个一个取。

[wannianliu]

如果除了userid=3之外，還應加一個條件
update a set monery=monery+(select monery from b where userid=a.userid)
where userid<>3

[上北软件培训工作室]

UPDATE tabA
SET money = money +(SELECT tabB.money FROM tabB WHERE tabB.userID = tabA.userID)
WHERE (userID <> 3)

[menuvb]

谢谢各位@
我试试看

[vinsonshen]

update a set a.monery = a.monery + b.monery from 表A as a ,表B as b where a.userid = b.userid and b.userid <> 3

[lxd99423]

表B有重复记录的话，需要先对B表汇总，否则会有问题

update a
set monery=a.monery+b.monery
from 表A a,(select userid,sum(monery) as monery from 表B group by userid) b
where a.id=b.id

[lxd99423]

--漏了一个条件
update a
set monery=a.monery+b.monery
from 表A a,(select userid,sum(monery) as monery from 表B where userid<>3 group by userid) b
where a.id=b.id

[caobin518]

lxd99423(苹果) 说得有道理。。。。

[zhaojiajin]

同意 wannianliu()的看法！
up!

[U2U2U2U2]

不明白你的意思
我的理解是a,b表按照userid建立关联然后在b表中排除userid=3的记录

UPDATE a SET monery = b.monery FROM a,b WHERE a.userid = b.userid AND B.userid<>3

[sujian2004515]

我也来学习了！！！

[deng1107]

update a set money=a.monery+b.monery from a,b where a.userid=b.userid and a.userid<>3

[华乐]

lxd99423(苹果)写对了，可以得到正确结果。