1.4.2.sql

清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码

CREATE VIEW SCT
(SNAME,CNAME,TNAME)
AS SELECT STUDENTS.SNAME,COURSES.CNAME,TEACHERS.TNAME
FROM CHOICES,STUDENTS,COURSES,TEACHERS
WHERE CHOICES.TID=TEACHERS.TID AND CHOICES.CID=COURSES.CID AND CHOICES.SID=STUDENTS.SID