如图所示,要怎么修改 WITH ORG( SELECT TRUEUNIT FROM CT_ORG_SOURCE WHERE (1=1) ${if(len(orgId) = 0,"","and FSEQ= " + orgId)} ) select t.* from (SELECT SOURCEUNIT, PROVINCENAME, round(sum(nvl(INCOME,0))/10000,2) as LJAMOUNT FROM CT_BI_INCOME where FYEAR = to_char(sysdate,'yyyy') ${if(len(orgId) = 0,""," and SOURCEUNIT in ('" + REPLACE(pv5,",","','") + "')")} GROUP BY SOURCEUNIT, PROVINCENAME )t left join CT_ORG_SOURCE s on s.TRUEUNIT = t.SOURCEUNIT order by s.FSEQ
|
最佳回答 |
||||
0
|
|