连接时数据表里面有null , '' , 中文

报错，连接时数据表里面有null , ‘’ , 中文。

select 1
  from (select xx.feiyongje
          from gg_wj_zjwj             wj,
               gg_zjwj_yjcssgyfy2     fy,
               gg_zjwj_yjcssgyfy_tkxx xx
         where wj.shenqingh = {string}
           and wj.rid = {long}
           and wj.wenjianjghsjbkey = fy.gg_zjwj_yjcssgyfy2_key
           and fy.gg_zjwj_yjcssgyfy2_key = xx.gg_zjwj_yjcssgyfy2_key
           and xx.feiyongzl in
               ('40872083405399', '40872083415399', '40872083425399',
                '40872083525381', '40872083535382', '40872083545383')) e
 where e.feiyongje <=
       (select sum(dsx.jiaofeije)
          from gg_fy_dsxfyjlb         dsx,
               gg_wj_zjwj             wj,
               gg_zjwj_yjcssgyfy2     fy,
               gg_zjwj_yjcssgyfy_tkxx xx
         where wj.shenqingh = {string}
           and wj.rid = {long}
           and wj.wenjianjghsjbkey = fy.gg_zjwj_yjcssgyfy2_key
           and fy.gg_zjwj_yjcssgyfy2_key = xx.gg_zjwj_yjcssgyfy2_key
           and (dsx.feiyongzldm between '40872083405340' and
               '40872083425379' or
               dsx.feiyongzldm in
               ('40872083525381', '40872083535382', '40872083545383'))
           and dsx.shenqingh = wj.shenqingh
           and dsx.shoujuh = xx.feiyongsjh)

解决过程:

• 直接包一层在外面写where，不行
• case when 转字符包一层，不行。
• 内连接一定用inner join
• 最终是把所有数据做了一遍清洗。