34,593
社区成员
发帖
与我相关
我的任务
分享
select * from Scenic where SortID like in (select id from XXXX);
select 1 from XXXX where charindex(','+ltrim(id)+',',','+t.sortid+',') > 0
[Quote=引用 3 楼 acherat 的回复:]
select * from Scenic t
where exists (select 1 from XXXX where charindex(','+ltrim(id)+',',','+t.sortid+',') > 0)