sql ¶à±íͳ¼ÆÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

±íA
  ÈÕÆÚ Ö§³ö½ð¶î 
  2010-04-01 120
  2010-04-02 250
  2010-05-01 100 
  2010-05-04 200
  2010-05-06 300


±íB
  ÈÕÆÚ ÊÕÈë½ð¶î 
  2010-04-05 100
  2010-04-07 200
  2010-05-05 300 
  2010-05-07 400
  2010-05-08 500

ÔõôÓÃÒ»¸öSQlÓïÃûµÃµ½ÈçÏÂ
  ÈÕÆÚ Ö§³ö½ð¶î ÊÕÈë½ð¶î 
  2010-04 370 300
  2010-05 600 1200

ÓÃÒ»¸öSQLÓï¾äͬʱͳ¼ÆÁ½¸ö±í²»Í¬×Ö¶Î










 

---

SQL code:
---²âÊÔÊý¾Ý---
if object_id('[A]') is not null drop table [A]
go
create table [A]([ÈÕÆÚ] datetime,[Ö§³ö½ð¶î] int)
insert [A]
select '2010-04-01',120 union all
select '2010-04-02',250 union all
select '2010-05-01',100 union all
select '2010-05-04',200 union all
select '2010-05-06',300
if object_id('[B]') is not null drop table [B]
go
create table [B]([ÈÕÆÚ] datetime,[ÊÕÈë½ð¶î] int)
insert [B]
select '2010-04-05',100 union all
select '2010-04-07',200 union all
select '2010-05-05',300 union all
select '2010-05-07',400 union all
select '2010-05-08',500

---²éѯ---
select convert(varchar(7),ÈÕÆÚ,120) ÈÕÆÚ,sum(Ö§³ö½ð¶î) Ö§³ö½ð¶î,sum(ÊÕÈë½ð¶î) ÊÕ