MySQL子查询详解

数据表tp_user的uuid为外键

数据表tp_score的uuid为主键

单表查询

--这里主键表查询uuid==13579和uuid==24680的结果
select *from tp_score where uuid in('13579','24680');
--这里外键表查询gender=='女'的字段并且返回uuid
select uuid from tp_user where gender = '女';//

合并-子查询

--通过查询外键表gender=='女'返回的uuid，再用这个uuid去主键表查询
select *from tp_score where uuid in (
	select uuid from tp_user where `gender` = '女'
)