1.2.34.sql

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

SELECT X.SID
FROM CHOICES AS X,CHOICES AS Y
WHERE X.CID=(
       SELECT CID
       FROM COURSES
       WHERE CNAME='c++'
      ) AND X.SID=Y.SID AND NOT (
      Y.CID=(
             SELECT CID
             FROM COURSES
             WHERE CNAME='java'
)
)