SELECT stu.* FROM course c,student stu,score s WHERE stu.s_id =s.s_id AND c.c_id=s.c_id AND c.c_name
IN (SELECT c.c_name FROM course c,student stu,score s WHERE stu.s_id=s.s_id AND s.c_id=c.c_id AND stu.s_id=‘01’)GROUP BY s.s_id
查询至少有一门课与学号为“01“的同学所学相同的同学的信息
最新推荐文章于 2023-07-24 17:24:12 发布