SELECT Invsale1.customer, Sum(Qsales2004.Jan) AS Jan之Sum, Sum(Qsales2004.Feb) AS Feb之Sum, Sum(Qsales2004.Mar) AS Mar之Sum, Sum(Qsales2004.Apr) AS Apr之Sum, Sum(Qsales2004.May) AS May之Sum, Sum(Qsales2004.Jun) AS Jun之Sum, Sum(Qsales2004.Jul) AS Jul之Sum, Sum(Qsales2004.Aug) AS Aug之Sum, Sum(Qsales2004.Sep) AS Sep之Sum, Sum(Qsales2004.Oct) AS Oct之Sum, Sum(Qsales2004.Nov) AS Nov之Sum, Sum(Qsales2004.Dec) AS Dec之Sum
FROM Invsale1 INNER JOIN qsales2004 AS qsales2004 ON invsale1.customer=qsales2004.customer
WHERE Invsale1.customer Like "10*"
GROUP BY invsale1.customer
ORDER BY invsale1.customer;
请问各位 这段程序求出来的是invsale1中各个月份的的和吗？
我是新手！ 先在这里谢过大家了

在线等待啊！ 帮帮我

冒人理偶~~！

路过