查询更新 0.0.0.0.0.0.0.0
表A，B都有字段 pid，value
更新A表value字段,加上B表中pid对应的value字段值
求方法。 sql
[解决办法]
update a表 set value=b.value
from a表
left join 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 A.VALUE = a.vlaue + b.value
FROM tableA a
INNER JOIN tableB b
ON a.pid = b.pid
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
