求个sql语句，两张表同一字段数值相加

A表： A1 A2 B表： A1 A2
1001 5.3 1001 2.1
1002 2.1 1002 1.6
sql insert 或者 update语句将 A表更新成如下：
表A A1 A2
1001 7.4
1002 3.7

第1个回答 2014-12-07

-- SQLServer:
update A表 a set a.A2 = a.A2 + b.A2 from B表 b where a.A1 = b.A1

-- Oracle\MySQL:
UPDATE A表 a, B表 b SET a.A2 = a.A2 + b.A2 WHERE a.A1 = b.A1

本回答被网友采纳

第2个回答 2014-12-07

update A
set A.A2=A.A2+(select B.A2 from B where B.A1=A.A1)
where exists (select 1 from B where B.A1=A.A1);

本回答被提问者采纳

相似回答

求个sql语句,两张表同一字段数值相加答：FROM A表 FULL JOIN B表 ON A表.A1=B表.A1

sql中同一字段的数值相加查询语句怎么写答：SELECT A, SUM(C) FROM TABLE GROUP BY A用分组查询就可以解决你说的问题

sql 求两张表中同一字段数值相加答：INSERT INTO A (A.A1) SELECTB.A1FROMBWHEREB.A1 NOT IN (SELECT A.A1 FROM A);UPDATE A,(SELECT C.A1, SUM(C.A2) AS A2 FROM ( SELECT * FROM A UNION ALL SELECT * FROM B ) C GROUP BY A1)D SET A.A2 = D.A2 WHERE A.A1 = D.A1 ...

两张表相同字段求和的SQL答：select coalesce(a.name,b.name), coalesce(a.dm,b.dm), sum(isnull(a.age+b.age,0))from a full join b on a.name=b.name and a.dm=b.dm group by coalesce(a.name,b.name), coalesce(a.dm,b.dm)

...个表a,b字段都一样,把b表的数据加到a表的sql语句该怎么写?_百度知 ...答：Insert into a(col1,col2,col3...) select col1,col2,col3... from b where not exists(select 1 from a where b.col1=a.col1and b.col2=a.col2 )--where条件为去除b表与a表中重复的数据

大家正在搜