select M.* from Member as M join [active] as A on charindex(','+convert(nvarchar,M.id)+',',A.UserIDList)>0 where A.id = 8
上面的语句在sqlserver里可以正常执行
怎么把它传写成在access也支持的呢? (是不是access不支持charindex?)
...全文
7511打赏收藏
一个sql语句的问题
select M.* from Member as M join [active] as A on charindex(','+convert(nvarchar,M.id)+',',A.UserIDList)>0 where A.id = 8 上面的语句在sqlserver里可以正常执行 怎么把它传写成在access也支持的呢? (是不是access不支持charindex?)