通过参数给出不同sql语句怎么写

heiqizero(提问者)

select a.wfrq,sum(a.wfsl) from vio_fact_wfjl a
where 1=1 and a.wfrq>=\'${kssj}\' and a.wfrq<=\'${jssj}\' and
a.wfxw in
${if(len(wfxwmc) == 0,\"select wfxw from vio_dim_codewfdm\",\"select wfxw from vio_dim_codewfxw where wflxmc=\'\"+wfxwmc+\"\'\")
and a.hpzl in (select hpzl from vio_dim_hpzl where dmsm1=\'${hphmmc}\')
group by a.wfrq    结果报null

回复

2017-05-26 14:25 

取消 回复

heiqizero(提问者)

select a.wfrq,sum(a.wfsl) from vio_fact_wfjl a
where 1=1 and a.wfrq>=\'${kssj}\' and a.wfrq<=\'${jssj}\' and  
a.wfxw in ${if(len(wfxwmc) == 0,\"select wfxw from vio_dim_codewfdm\",\"select wfxw from vio_dim_codewfxw where wflxmc=\'\"+wfxwmc+\"\'\")}
and a.hpzl in (select hpzl from vio_dim_hpzl where dmsm1=\'${hphmmc}\')
group by a.wfrq

报缺失表达式

回复

2017-05-26 14:31 

取消 回复

heiqizero(提问者)

谢啦。。。。

回复

2017-05-26 14:40 

取消 回复