select "& r_qx &" as 日期,djhm as 单据号,xtzl.ma as 商品码,sum(sl) as 数量,dj as 单价,sum(je) as 金 额,xtzl.pm as 品名,memo as 备注,"& dbfx &".jyb as 经营部 from xtzl,ppk,"& pth_m & dbfx &"
where " & eq("xtzl.ma", sp_m) & " and " & eq("xtzl.ppbm", pp_m) & " and " & eq("ppk.jyb", jyb_m) & " and " & dbfx & ".ma=xtzl.ma and "& dbfx &".ppbm=xtzl.ppbm and " & dbfx & ".jyb=ppk.jyb and
" &dbfx & ".ppbm=ppk.ppbm and " & r_qx &">='"& dat1 &"' and "& r_qx &" <='"& dat2 &"' order by "& r_qx &",djhm group by djhm
select "& r_qj &" as 日期,djhm as 单据号,xtzl.ma as 商品码,sum(sl) as 数量,dj as 单价,sum(je) as 金额,xtzl.pm as 品名,memo as 备注,"& dbfj &".jyb as 经营部 from xtzl,ppk,"& pth_m & dbfj &"
"where " &eq("xtzl.ma", sp_m) & " and " & eq("xtzl.ppbm", pp_m) & " and " & eq("ppk.jyb", jyb_m) & " and " &dbfj & ".ma=xtzl.ma and "& dbfj &".ppbm=xtzl.ppbm and " & dbfj & ".jyb=ppk.jyb and
<%if request.QueryString("start") <>"" then%>
<%if cint(start)>0 then%>
<a href="search.asp?q= <%=q%>&start= <%if request.Query ......
