SELECT pr_name,
sub_pr_name,
SUM(op_bal)AS opb,
SUM(Inqty)AS inqty1
FROM purchasereport
WHERE SDate
BETWEEN #"+df1.format(from_d)+"#
AND #"+df1.format(to_d)+"#
AND comp_name='"+cb.getSelectedItem()+"'
GROUP BY comp_name,pr_name,sub_pr_name
但只有当起始日期为01或02时,它才能给出结果。