92344,92345, select cbzx ,fyxm,fyxmid,cbzxid,sjxm,sum(to_number(replace(bxje,',',''),'99999999999.00') ) as he,b.b_amount from uf_cwbxtjb a,oa.uf_budgetbase b
where fyxmid not in (1,2,3) and cbzx is not null and fyxm is not null and orgid=81 and b.centername= a.cbzx and
a.sjxm=b.subject group by fyxm,cbzx,fyxmid,cbzxid,sjxm,b.b_amount
union
select a.cbzx,a.fyxm,a.fyxmid,a.cbzxid,a.sjxm,sum(to_number(replace(a.baoxiaozongjine,',',''),'999999999999.00') ) as he,b.b_amount from
( select distinct(requestid),fyxmid,orgid,cbzx,fyxm,cbzxid,baoxiaozongjine,'差旅费' as sjxm from uf_cwbxtjb where fyxmid in (1,2,3) and sjxm is null) a,
oa.uf_budgetbase b
where fyxmid in (1,2,3) and orgid = 81 and a.sjxm=b.subject and b.centername= a.cbzx
group by a.fyxm,a.cbzx,a.cbzxid,a.fyxmid,a.sjxm,b.b_amount order by cbzxid
在数据库执行的时候没有问题
92347,实在是找不到原因,请教大神
