SELECT wm_concat(USERRELATIONID) FROM USER_UNIT WHERE ORGMENBERID='zhangshang' 这个我查询出来是701,702,703这样的数据, 我需要放到WHERE条件中IN出来 SELECT USERGROUPID FROM V_USER_CREGION WHERE USERGROUPID IN ('') =========不知道怎么拼接单引号和双引号调整不好======== SELECT USERGROUPID FROM V_USER_CREGION WHERE 1=1 ${if(len(a)=0,"","USERGROUPID IN ('SUBSTITUTE(SELECT wm_concat(USERRELATIONID) FROM USER_UNIT WHERE ORGMENBERID='zhangshang',",","','")")} 这个SQL求解》??? =========================================== 顺便问一句if条件 ${if(len(a)=0,"","") 我这个参数a我可以直接写SQL吗? 'SELECT wm_concat(USERRELATIONID) FROM USER_UNIT WHERE ORGMENBERID='zhangshang' |