有 teacher, student, course, score四个表
-- 查询有课的学生的学号,姓名和所学的课号及成绩。
SELECT student.学号, student.姓名,score.课号, score.成绩
FROM student JOIN score
ON student.学号=score.学号;
有 teacher, student, course, score四个表
-- 查询有课的学生的学号,姓名和所学的课号及成绩。
SELECT student.学号, student.姓名,score.课号, score.成绩
FROM student JOIN score
ON student.学号=score.学号;