| ,, 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 在数据库执行的时候没有问题  ,实在是找不到原因,请教大神 |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
