mysql报错-Unkown table ‘student‘

修改如下：如果后面查询的表用了别名，前面不能再用表明，要用别名

//student：学生表，sc：课程表
//查询“01”课程比“02”课程成绩高的学生的信息及课程分数
SELECT a.*,b.score
FROM student a
 JOIN (SELECT * FROM sc WHERE cid = '01') B ON A.sid = b.sid
 JOIN (SELECT * FROM sc WHERE cid = '02') C ON C.sid = b.sid
 WHERE 
 b.score>c.score