一个关于求和的SQL语句,大家帮我看看
从Wage2008 表里取出当前月份之前的bjts,和sjts总和,请问怎么写这个句子,下面是我写的不对,ny(年月),infoid(编号),aa = Val(Format(Now, "YYYYMM"))mySQL1 = "SELECT ny,bzmc,infoid,name,SUM(bjts) as LJBJTS,SUM(sjts) AS LJSJTS FROM Wage2008 WHERE ny< 'aa' AND infoid='" & txt(0).Text & "'"
Rs.Open mySQL1, AdoCon, adOpenDynamic, adLockOptimistic --------------------编程问答-------------------- 你根据什么求和???
Group by语句呢! --------------------编程问答-------------------- 哦,不用分组,我刚刚摸索出来了,谢谢你啊 --------------------编程问答-------------------- 楼上,没注意到 mySQL1 中有 WHERE 子句限定了编号?
mySQL1 = "SELECT ny,bzmc,infoid,name,SUM(bjts) as LJBJTS,SUM(sjts) AS LJSJTS FROM Wage2008 WHERE ny < '" & aa & "' AND infoid='" & txt(0).Text & "'"
补充:VB , 数据库(包含打印,安装,报表)