上个帖子自己写错了语句，再发一个贴问问高手这个SQL语句问题，算是道歉了:)

[tao999]

写错了

select


sum(a.aa) as aa,

sum(b.aa) as bb


from table_1 a, table_1 b

where a.GSMC= 3 AND YEAR(a.MDATE)=2005 and MONTH(a.MDATE)=2
and b.GSMC=3 and YEAR(b.MDATE)=2005 and MONTH(b.MDATE)<=2

这个语句查询得到的值有问题。。

[askwho]

这个语句得到的值是重复的

[tao999]

是的，是实际值的倍数，怎么解决，我不想把语句拆开

[teaky2002]

还没见过这么写sql的.

[tao999]

两个条件不一样，一个是得到月累计值，一个是年累计值

[jlwei888]

from table_1 a, table_1 b 都 是一个表啊，
你只能每个sum 写成一个语句。在一起肯定不对。

[peanutsun]

可以想把你的目的写出来,之后讨论一下怎么写

[jlwei888]

分开写成两条语句

[tao999]

我想一次把月累计和年累计得到，不知道有办法嘛？

[ys_wangtao]

建议用临时表，建立代表年和月的临时表
比如
with temmonth as
(select sum(aa),mdate from table_1 where aGSMC= 3 AND YEAR(MDATE)=2005 and MONTH(MDATE)=2),
temyear as
(select sum(aa),mdate from table_1 where aGSMC= 3 AND YEAR(MDATE)=2005 and MONTH(MDATE)<=2)
select temmonth.aa,temyear.aa from temmonth,temyear where temmonth.mdate=temyear.mdate

[垲垲]

很简单嘛，不知道这样对不对：

select


sum(a.aa) as aa,

(select sum(b.aa) from table_1 b where b.GSMC=3 and YEAR(b.MDATE)=2005 and MONTH(b.MDATE)<=2
)as bb


from table_1 a

where a.GSMC= 3 AND YEAR(a.MDATE)=2005 and MONTH(a.MDATE)=2

[jj4567892000]

两个没有任何关联的表作查询，记录数是默认作笛卡尔集，即表1记录数*表2记录数

[bflovesnow]

同意楼上，2个表有关系就行了。