sql选定同时符合多个值记录

sql选出同时符合多个值记录?select * from testsqlWHERE HOBBYbasketball and NAME in(select NAMEfrom

sql选出同时符合多个值记录

?

select * from testsqlWHERE HOBBY='basketball' and NAME in(      select NAME      from testsql      where HOBBY ='badminton')
?

?