Mysql Inner join 内连接查询

#主句
select s.*,sc1.s_score as score_01,sc2.s_score as score_02
from student s
#内联查询，分数表中的01课程
inner join (
	select * from score where c_id = 1
) sc1
on s.s_id = sc1.s_id
#内联查询，分数表中的02课程
inner join (
	select * from score where c_id = 2
) sc2
on s.s_id = sc2.s_id
where sc1.s_score <sc2.s_score;