SELECT s.student_name,c.course_name FROM student s,course c,student_course sc WHERE s.student_id=sc.student_id AND c.course_id=sc.course_id AND s.student_name='张三' AND sc.semmster='2006年第一学期'SELECT s.student_name,c.course_name FROM student s WHERE NOT EXISTS (SELECT * FROM course c WHERE NOT EXISTS (SELECT * FROM student_course sc WHERE s.student_id=sc.student_id AND c.course_id=sc.course_id ) )
FROM student s,course c,student_course sc
WHERE s.student_id=sc.student_id AND c.course_id=sc.course_id AND s.student_name='张三' AND sc.semmster='2006年第一学期'SELECT s.student_name,c.course_name FROM student s
WHERE NOT EXISTS
(SELECT * FROM course c
WHERE NOT EXISTS
(SELECT * FROM student_course sc
WHERE s.student_id=sc.student_id AND c.course_id=sc.course_id
)
)