SELECT stu.* FROM student stu
WHERE stu.s_id NOT IN
(SELECT s.s_id FROM score s,teacher t,course c WHERE t.t_name=“张三” AND t.t_id=c.t_id AND c.c_id=s.c_id)
AND stu.s_id IN (SELECT s.s_id FROM score s,teacher t,course c WHERE t.t_name=“李四” AND t.t_id=c.t_id AND c.c_id=s.c_id)
查询学过编号为“01“但是没有学过编号为“02“的课程的同学的信息
最新推荐文章于 2023-04-16 18:45:00 发布