CREATE VIEW v1 as SELECT course.course_name AS C_NAME,score.score AS S_SORCE,score.student_id AS S_ID
FROM course INNER JOIN score
ON course.course_id=score.course_id
ORDER BY score.course_id
结果展示:
CREATE VIEW v1 as SELECT course.course_name AS C_NAME,score.score AS S_SORCE,score.student_id AS S_ID
FROM course INNER JOIN score
ON course.course_id=score.course_id
ORDER BY score.course_id
结果展示: