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
ÎÒÔ±¾ÊÇѧjspµÄ¿ÉÕÒÁËÒ»¸öASPµÄ¹«Ë¾£¡ÎÒÒªÖØÐÂѧϰ£¡ ѧϰASP£¡ Ï£Íû´ó¼ÒÍÆ¼öÒ»±¾ºÃÊ鏸ÎÒлл
<ASP3.0¸ß¼¶±à³Ì> ÍøÉÏÓеç×Ó°æµÄ
·¢ÏÖÍøÉÏaspÐÅϢʱ×î¶àµÄ ±ÈÆäËûµÄ¶¼¶àºÃ¶à
yun
ÕÒ±¾ÓÐÓ¦ÓÃÊÂÀýµÄA ......