练习MySQL联表查询时遇到这样一道题
- 问题: 查询"生物课程"比"物理课程"成绩高的所有学生的相关信息
- 出错指令:
1 SELECT student.sid AS '学号', student.sname AS '姓名', course.cname AS '课程', score.num AS '成绩'
2 FROM student INNER JOIN course INNER JOIN score
3 ON student.sid=score.student_id AND course.cid=score.course_id AND course.cid=2
4 WHERE score.num < (SELECT score.num