34,588
社区成员
发帖
与我相关
我的任务
分享
select
b.id,b.name
from
t2 a ,t1 b
where
charindex(','+ltrim(b.id)+',',','+a.city+',')>0
and
a.id=1
select a.*
from 表a a,表b b
where charindex(','+rtrim(a.id)+',',','+b.city+',')>0
and b.name='张三'
select b.id,b.name
from t2 a inner join t1 b on charindex(','+ltrim(b.id)+',',','+a.city+',')>0
where a.id=1
select a.*
from 表a a,表b b
where charindex(','+a.id+',',','+b.city+',')>0
and b.name='张三'