${if(len(oop)!=0 && oop != "00000001" && len(yg)==0 , "select hx.dwmc,hxzs,zxzs,sum(hxzs+zxzs) from (select xx.dwmc, sum(dm.xmdzzjf) hxzs from dm_hxxm_info dm left join xx_yxsdwjbsj xx on dm.dwh=xx.dwh where 1=1 group by xx.dwmc )hx left join (select xx.dwmc, sum(dm.xmdzzjf) zxzs from dm_zxxm_info dm left join xx_yxsdwjbsj xx on dm.dwh=xx.dwh where 1=1 group by xx.dwmc ) zx on hx.dwmc=zx.dwmc where 1=1 + if(len(tbsj_ks) == 0,"","and tjny >= '" +tbsj_ks + "'") + if(len(tbsj_js) == 0,"","and tjny <= '" +tbsj_js + "'") group by hx.dwmc,hxzs,zxzs order by hxzs desc", "") } 报错提示我的参数不对 |
最佳回答 |
||||
0
|
|