56,679
社区成员
发帖
与我相关
我的任务
分享
select b.name
from tab1 a inner join tab1 b on a.name=b.remark
where a.text='111'
select
name
from
tab1
where
remark in(
select
name
from
tab1
where
`text`='111'
)
--或者
select
a.name
from
tab1 a,
tab2 b
where
a.remark=b.name
and
b.`text`='111'
select
name
from
tab1
where
remark in(
select
name
from
tab1
where
`text`='111'
)
--或者
select
a.name
from
tab1 a,
tab2 b
where
a.remark=b.name
and
b.`text`='111'