1.2.30.sql

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

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'
)