1.2.33.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 12 行

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