| 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) |
