34,593
社区成员
发帖
与我相关
我的任务
分享
UPDATE A
SET A.VALUE = a.vlaue + b.value
FROM tableA a
INNER JOIN (SELECT pid, value=SUM(value) FROM tableB) b
ON a.pid = b.pid
[/quote]
....唉,我居然没想到UPDATE A
SET A.VALUE = a.vlaue + b.value
FROM tableA a
INNER JOIN (SELECT pid, value=SUM(value) FROM tableB) b
ON a.pid = b.pid
UPDATE A
SET A.VALUE = a.vlaue + b.value
FROM tableA a
INNER JOIN tableB b
ON a.pid = b.pid
update a表 set value=b.value
from a表
inner join b表 on a.pid=b.pid
update a表 set value=b.value
from a表
left join b表 on a.pid=b.pid