select a.wfrq,sum(a.wfsl) from vio_fact_wfjl a
where a.wfrq>='${kssj}' and a.wfrq<='${jssj}' and
a.wfxw in (select wfxw from vio_dim_codewfdm where wfxwmc='${wfxwmc}')
and a.hpzl in (select hpzl from vio_dim_hpzl where dmsm1='${hphmmc}')
group by a.wfrq
这是我的sql,但是当参数wfxwmc=""时,我要前面的sql变成a.wfxw in (select wfxw from vio_dim_codewfdm);同样,当hphmmc=""时,a.hpzl in (select hpzl from vio_dim_hpzl)