sql("测试","SELECT DISTINCT bm FROM 表 where id in ('"+M3+"')",1)
SQL函数中in的写法是这么写的吗?
对的
但是注意M3的分隔符是','
==========
如果是逗号,改成这个写法
sql("测试","SELECT DISTINCT bm FROM 表 where id in ('"+replace(M3,",","','")+"')",1)
M3的格式是 1','2','3
-----
如果M3的格式是1,2,3 就把M3改成 REPLACE(M3,",","','")
可以