sql ÇóÁ½¸ö±íÖÐÏàͬÁеĺÍ×öΪÐÂÁÐ

ÓÐÁ½ÕűíA B

A±í

±àºÅ  ÊýÁ¿
  1    20
  2    25
  3    10


B±í

  ±àºÅ  ÊýÁ¿
  1    10
  2    15
  3    20
  4    9


ÏÖÔÚÏëÈÃA BºÍ³É C±í

  C±í
  ±àºÅ  ÊýÁ¿
  1    30
  2    40
  3    30
  4    9

  ÎÒSQLÔõôд??? ¾ÍÊÇÈà A B±íµÄÊýÁ¿ Ïà¼Ó

---

SQL code:
SELECT ±àºÅ,SUM(ÊýÁ¿) AS ÊýÁ¿
INTO C
from
(
SELECT * from A
UNION ALL
SELECT * from B
) T
GROUP BY 񅧏

---

SQL code:
---²âÊÔÊý¾Ý---
if object_id('[A]') is not null drop table [A]
go
create table [A]([±àºÅ] int,[ÊýÁ¿] int)
insert [A]
select 1,20 union all
select 2,25 union all
select 3,10
GO
if object_id('[B]') is not null drop table [B]
go
create table [B]([±àºÅ] int,[ÊýÁ¿] int)
insert [B]
select 1,10 union all
select 2,15 union all
select 3,20 union all
select 4,9
GO

SELECT ±àºÅ,SUM(ÊýÁ¿) AS ÊýÁ¿
INTO C
from
(
SELECT * f