ASP union allÎÊÌâ¼±£¡£¡

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