求高手做下报表的问题
表A
ftid paytime
123 2010-9-1
124 2011-6-7
1231 2010-11-12
1232 2010-11-30
表B
ftid id num amt
123001244
124001366
12310016132
12320012 44
现在就想得到在每个年度，月度，001商品的总数和总金额，也就是得到下面这样
年度月度总num总amt
20109244
2010118176
20116366
[解决办法]
select year(a.paytime),month(a.paytime),sum(b.num),sum(b.amt) from a
inner join b on a.ftid=b.ftid
where b.id='001' and paytime between '2010-1-1' and '2011-11-2'
group by year(a.paytime),month(a.paytime)
