sql查询问题!
我现在有表
shpxx
字段sp_id,sp_name,dl_id,xl_id,sp_price1....
pifa(批发主表)
字段pf_id,pf_date...
pifamx(批发明细表)
字段pf_id,sp_id,quanttity(数量)...
我现在作一个视图
SELECT a.SP_ID, a.SP_NAME,a.SP_INPRICE, a.DL_ID, a.XL_ID, b.pfmount, a.SP_PRICE * b.pfmount AS pfmoney from shpxx a left outer join(select sp_id,sum(quantity) as pfmount from pifamx group by sp_id) b on a.sp_id=b.sp_id
我现在想做在一段时间的批发数量的统计也可以做如
SELECT a.SP_ID, a.SP_NAME,a.SP_INPRICE, a.DL_ID, a.XL_ID, b.pfmount, a.SP_PRICE * b.pfmount AS pfmoney from shpxx a left outer join(select sp_id,sum(quantity) as pfmount from pifamx where pf_id in
(select pf_id from pifa where pf_date between :p1 and :p2)
group by sp_id) b on a.sp_id=b.sp_id
但是我现在想做查询就是在一段时间查某一种商品的批发统计不知如何做