求教VB编程问题,急!
来源:百度知道 编辑:UC知道 时间:2024/05/11 13:18:27
我想实现查询出的数据是按日期分组的结果,但不知道怎么编,以下是程序:
SELECT rcvdbill.RcvdBillID,rcvdbill.RcvdBillNo,rcvdbill.RcvdDate,rcvdbill.RcvdNum,rcvdbill.RcvdMoney,rcvdbill.RcvdTotal,rcvdretail.booknum,RcvdBill.PayMoney AS PayMoney,
PayDetail_YW_Bill.PayMoney AS Current_PayMoney,(RcvdTotal-RcvdBill.PayMoney) as NoPayMoney
FROM (RcvdBill INNER JOIN PayDetail_YW_Bill ON RcvdBill.RcvdBillID=PayDetail_YW_Bill.BillID left join rcvdretail on rcvdbill.rcvdbillid=rcvdretail.rcvdbillid)
WHERE PayDetail_YW_Bill.PayBillID=12 AND PayDetail_YW_Bill.TypeFlag=0
(我在where这里加上了group by rcvddate,但每次运行都提示:“在选择列表中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中”)希望给为高手指点我怎么样才可以实现该功能
SELECT rcvdbill.RcvdBillID,rcvdbill.RcvdBillNo,rcvdbill.RcvdDate,rcvdbill.RcvdNum,rcvdbill.RcvdMoney,rcvdbill.RcvdTotal,rcvdretail.booknum,RcvdBill.PayMoney AS PayMoney,
PayDetail_YW_Bill.PayMoney AS Current_PayMoney,(RcvdTotal-RcvdBill.PayMoney) as NoPayMoney
FROM (RcvdBill INNER JOIN PayDetail_YW_Bill ON RcvdBill.RcvdBillID=PayDetail_YW_Bill.BillID left join rcvdretail on rcvdbill.rcvdbillid=rcvdretail.rcvdbillid)
WHERE PayDetail_YW_Bill.PayBillID=12 AND PayDetail_YW_Bill.TypeFlag=0
(我在where这里加上了group by rcvddate,但每次运行都提示:“在选择列表中无效,因为该列既不包含在聚合函数中,也不包含在 GROUP BY 子句中”)希望给为高手指点我怎么样才可以实现该功能
汗,这个不是VB吧~
你select出来的column必须全部出现在group by 里的
比如说
select a, b, c
from table
group by a,b,c,d
这个是可以的
但是
select a, b, c
from table
group by a
这个就不可以了
建议你用子查询~