-- table2 的 name 作为 table1的条件
select
*
from
table1
where
name
in
(
select
name
from
table2)
--如果有多条语句,可以使用字段相加再等于
select
*
from
table1
where
fld1+fld2
in
(
select
fld1+fld2
from
table2)
--也可以使用INNER JOIN 进行查询
select
a.*
from
table1 a
inner
join
(
select
name
from
table2
group
by
name
) b
on
a.
name
=b.
name