有 teacher, student, course, score四个表
-- 查询没课的学生的学号,姓名和性别。
SELECT student.学号, student.姓名,student.性别
FROM student LEFT JOIN score
ON student.`学号` = score.`学号`
WHERE score.`课号` IS NULL;
有 teacher, student, course, score四个表
-- 查询没课的学生的学号,姓名和性别。
SELECT student.学号, student.姓名,student.性别
FROM student LEFT JOIN score
ON student.`学号` = score.`学号`
WHERE score.`课号` IS NULL;