report.sql

用vb做一个学生管理系统（数据库sql）

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