1.2.28.sql

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

SELECT SNAME
FROM STUDENTS
WHERE EXISTS
(
SELECT *
FROM CHOICES X
WHERE X.CID='10001' AND X.SID=STUDENTS.SID
)