7,714
社区成员
发帖
与我相关
我的任务
分享
create table a(id int, name varchar(10), chengji int)
insert into a values(1 , '李' , 50)
insert into a values(2 , '王' , 30)
insert into a values(3 , '李' , 70)
insert into a values(4 , '王' , 80)
create table b(id int, name varchar(10), chengji int)
insert into b values(1 , '李' , 40)
insert into b values(2 , '王' , 20)
insert into b values(3 , '陈' , 40)
insert into b values(4 , '王' , 70)
go
select name , sum(chengji) chengji from
(
select * from a
union all
select * from b
) t
group by name
drop table a , b
/*
name chengji
---------- -----------
陈 40
李 160
王 200
(所影响的行数为 3 行)
*/
select name , sum(chengji) chengji from
(
select * from a
union all
select * from b
) t
group by name