笔者sql知识有限,欢迎大家提供更好的方法建议
相关表如下
student:
sc:
course:
1,选择‘01’课程未选02课程的姓名,学科名称,该科成绩
SELECT s.Sname,c.`
Cname`,sc.score
FROM (student s LEFT JOIN sc ON s.`S#`=sc.`S#`)
LEFT JOIN course c ON c.`C#`=sc.`C#`
WHERE sc.`S#`=(SELECT sc.`S#` FROM sc
WHERE sc.`C#`='01' AND sc.`