数据库系统教程 何玉洁 李宝安 第6章 高级查询1新.pptVIP

示例 例24 查询同时出现在t1表和t2表中的记录。 SELECT * from t1 INTERSECT SELECT * from t2 * * 示例 例25 查询同时出现在t1、t2和t3表的记录。 SELECT * from t1 INTERSECT SELECT * from t2 INTERSECT SELECT * from t3 * * 示例 例26 查询李勇和刘晨所选的相同课程,列出课程名和学分。（即同时被李勇和刘晨选的课程） SELECT Cname,Credit FROM Student S JOIN SC ON S.Sno = SC.Sno JOIN Course C ON C.Cno = SC.Cno WHERE Sname = 李勇 INTERSECT SELECT Cname,Credit FROM Student S JOIN SC ON S.Sno = SC.Sno JOIN Course C ON C.Cno = SC.Cno WHERE Sname = 刘晨 * * 例26另一种实现方法 SELECT Cname,Credit FROM Course WHERE Cno IN ( --李勇选的课程 SELECT Cno FROM SC JOIN Student S ON S.Sno = SC.