2-14.sql
上传用户:lyj12345cj
上传日期:2010-02-12
资源大小:600k
文件大小:0k
源码类别:

SQL Server

开发平台:

SQL

  1. select distinct coursename,studentname,teachername,grade
  2. from students,courses,enrolls,sections,teachers
  3. where courses.course=sections.course and sections.course=enrolls.course and students.student=enrolls.student and teachers.teacher=sections.teacher and students.student=enrolls.student
  4. group by enrolls.student,courses.coursename,students.studentname,teachers.teachername,enrolls.grade