1.2.30.sql

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

SELECT TID
FROM CHOICES
WHERE CHOICES.CID=
(
SELECT COURSES.CID
FROM COURSES
WHERE COURSES.CNAME='c++'
)
UNION
SELECT TID
FROM CHOICES
WHERE CHOICES.CID=
(
SELECT CID
FROM COURSES
WHERE COURSES.CNAME='java'
)