22,211
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
isnull((select sum( gxe ) From cwkj_gxe where convert(varchar(7),yearmonth,120) =convert(varchar(7),M_zjl_sp.yearmonth,120) and fyxm_jt_lm = 'sc-ry_gz'),0) as sc_hxe_ry_gz,
isnull((select sum( gxe ) From cwkj_gxe where convert(varchar(7),yearmonth,120) =convert(varchar(7),M_zjl_sp.yearmonth,120) and fyxm_jt_lm = 'sc-ry_fl'),0) as sc_hxe_ry_fl,
isnull((select sum( gxe ) From cwkj_gxe where convert(varchar(7),yearmonth,120) =convert(varchar(7),M_zjl_sp.yearmonth,120) and fyxm_jt_lm = 'sc-ry_tx'),0) as sc_hxe_ry_tx,
isnull((select sum( gxe ) From cwkj_gxe where convert(varchar(7),yearmonth,120) =convert(varchar(7),M_zjl_sp.yearmonth,120) and fyxm_jt_lm in('sc-ry_tx','sc-ry_gz','sc-ry_fl')),0) as asdf ,
--这样写,用in
isnull((select sum( gxe ) From cwkj_gxe where convert(varchar(7),yearmonth,120) =convert(varchar(7),M_zjl_sp.yearmonth,120) and fyxm_jt_lm in('sc-ry_tx','sc-ry_gz','sc-ry_fl'),0) as asdf ,