基本SQL问题

[new100bits]

Table1结构如下：
表名：rpt_newadd
Date NewAdd(日新增量)
20050701 50
20050702 70
... ...
20060101 100
20060102 200
20060103 150
... ...

Table2结构如下：
表名：rpt_yearplan
Year PlanCnt
2005 1000
2006 2000
... ...

现在要得出这样一张表：

Day PlanCnt(年计划值) NewMonthSum(当月合计) YearSum(当年累计)
200507 1000 300 300
... ... ... ...
200601 2000 800 800

如果今天是20060112，
当月合计就是从20060101---20060112的值，当年累计就是20060101---20060112的值
恳求各位大虾的帮助！

[子陌红尘]

try：

select
Year(b.Date) ,
Month(b.Date),
a.PlanCnt ,
sum(NewAdd) as NewMonthSum,
(select sum(NewAdd) from rpt_newadd where Year(Date)=Year(b.Date) and Month(Date)<=Month(b.Date)) as YearSum
from
rpt_yearplan a,
rpt_newadd b
where
a.Year=Year(b.Date)
group by
Year(b.Date),Month(b.Date),a.PlanCnt

[子陌红尘]

select
Char(Year(b.Date))||Char(Month(b.Date)) as Day,
a.PlanCnt,
sum(NewAdd) as NewMonthSum,
(select sum(NewAdd) from rpt_newadd where Year(Date)=Year(b.Date) and Month(Date)<=Month(b.Date)) as YearSum
from
rpt_yearplan a,
rpt_newadd b
where
a.Year=Year(b.Date)
group by
Year(b.Date),Month(b.Date),a.PlanCnt
order by
Char(Year(b.Date))||Char(Month(b.Date))

[ibanez550]

怎么没有键值呢？你依据什么统计呢？

[Mr_Bean]

实际上你这种功能完全可以通过table1统计得到
没有必要去关联另外的那个表