*
-- 学过01，且学过02
-- 学过01
SELECT sc.SID FROM SC sc WHERE sc.CID = '01';
-- 学过02
SELECT sc.SID FROM SC sc WHERE sc.CID = '02';
-- 连起来
SELECT stu.* FROM Student stu, SC sc
WHERE stu.SID = sc.SID AND sc.CID = '01'
AND sc.SID IN (
SELECT sc.SID FROM SC sc WHERE sc.CID = '02'
)
Original: https://www.cnblogs.com/OnlyOnYourself-lzw/p/16620748.html
Author: OnlyOnYourself-Lzw
Title: Question09-查询学过编号为”01″并且也学过编号为”02″的课程的同学的信息
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/621378/
转载文章受原作者版权保护。转载请注明原作者出处！