Question

新人求SQL语句，根据A表中的S条件 在B表中查询完整资料！

新人求完整SQL语句，根据A表中的S条件(数字)， 在B表中查询完整资料！

Answer 1

select * from a where id in (select * from b where....)
或者使用 inner join

Answer 2

问题表述得实在太含糊了
我按自己理解的意思先写写看
select * from a,b where a.s=b.s

Answer 3

select * from B
inner join A
on B.S = A.S
where A.S = '条件'

Answer 4

select * from B where B.S in (sleect A.S from A)

Answer 5

select * from B where S in(select S from A)