查询所有学生的课程及分数情况(存在学生没成绩,没选课的情况)
select student.sname, cid, score from student
left join sc
on student.sid = sc.sid;
查询所有学生的课程及分数情况(存在学生没成绩,没选课的情况)
select student.sname, cid, score from student
left join sc
on student.sid = sc.sid;