ASP用过ORACLE数据库的大哥，进来帮我解决个问题。

[ykhxb]

在ASP页面里不能运行在SQL里调试通过的 select语句，
rs_1.Source = "select xmbm,xmmc,kmmc,sum(qcye) as 期初余额,sum(jfse) as 借发生额,sum(dfse) as 贷发生额,sum(qcye - jfse + dfse) as 余额
from (
select t1.xmbm as xmbm,t1.xmmc as xmmc, t3.kmmc as kmmc,t2.qcye1 as qcye,0 as jfse,0 as dfse
from uferpxz.zz_xm t1,uferpxz.zz_xmye t2,uferpxz.zz_km t3
where t1.dwbm = t2.dwbm and
t1.dwbm = t3.dwbm and
t2.kmbm = t3.kmbm and
t1.xmbm = t2.xmbm1 and
t1.dlbm in ('03') and
t1.dwbm = '0901' and
t2.kjqj = '01' and
t2.kjnd = '2003'
union
select t1.xmbm,t1.xmmc, t3.kmmc,0 as qcye,sum(t2.jfse1) as jfse, sum(t2.dfse1) as dfse
from uferpxz.zz_xm t1,uferpxz.zz_fl t2,uferpxz.zz_km t3,uferpxz.zz_pz t4
where t1.dwbm = t2.dwbm and
t1.dwbm = t3.dwbm and
t1.dwbm = t4.dwbm and
t2.glh = t4.glh and
t2.kmbm = t3.kmbm and
t1.xmbm = t2.xmbm1 and
t1.dlbm in ('03') and
t1.dwbm = '0901' and
t4.kjnd = '2003'
group by t1.xmbm,t1.xmmc,t3.kmmc
)
group by xmbm,xmmc,kmmc"


报错：

错误类型：
Microsoft VBScript 编译器错误 (0x800A0409)
/ykkj3/sckj/admin_yecx2.asp, 第 117 行, 第 120 列
rs_1.Source = "select xmbm,xmmc,kmmc,sum(qcye) as 期初余额,sum(jfse) as 借发生额,sum(dfse) as 贷发生额,sum(qcye - jfse + dfse) as 余额


关于这个多表操作，都要做些什么工作，数据源是用ODBC的。

如果有类似的源代码，请发我一份，感激不尽。

[ykhxb]

高手在哪里啊？？？？？？？？？？？？？？

[anita2li]

chinese change to english

[ykhxb]

这个没用的，我都把它转换成数字都不行啊，，，，


有没有人做过类似的啊，我就要看一下源代码