处理方法:
select ksid,ksmc from ggzd_tks where CHARINDEX(','+LTRIM(ksid)+',',','+(select csz from xt_tcssz where csmc = '门诊科室')+',')>0
错误原语句:select ksid,ksmc from ggzd_tks where ksid in (select csz from t_tcssz where csmc = '门诊科室') 将ksid和csz用CHARINDEX进行处理
效果如下: