表:course
score
student
teacher
查询思路:
1.查询所有学习过“01”课程的学生;
2.查询所有学习过“02”课程的学生;
3.内部关联学生的SID
代码:
SELECT 语文.SId AS 学号,student.Sname AS 姓名
FROM
(SELECT *
FROM score
WHERE score.CId=01) 语文
INNER JOIN
(SELECT*
FROM score
WHERE score.CId=02) 数学
ON 语文.SId=数学.SId
LEFT JOIN student ON 语文.SId=student.SId