新建 文本文档 (6).txt

一个数据库SQL语言

select studentname 学生姓名,courses.coursename 课程名,teachername 教师姓名,grade 成绩   
from students,courses,teachers,enrolls,sections   
where teachers.teacher=sections.teacher and sections.course=enrolls.course and students.student=enrolls.student and courses.course=enrolls.course   

select studentname 学生姓名,courses.coursename 课程名,teachername 教师姓名,grade 成绩 
from students,courses,teachers,enrolls,sections 
where teachers.teacher=sections.teacher and sections.course=enrolls.course and students.student=enrolls.student and courses.course=enrolls.course