report.sql

来自「用vb做一个学生管理系统（数据库sql）」· SQL 代码 · 共 2 行

create view report as
select d.Class_Id,d.Class_Name,c.Student_Id,c.Student_Name,a.LessonId,a.LessonName,b.Score from Lessons a,Scores b,Students c,Classes d where a.LessonId=b.LessonId and c.Student_Id=b.Student_Id and c.Class_Id=d.Class_Id