MySQL ●000 案例:查询与“刘晨”在一个系学习的学生 select b FROM Student a student b WHERE a sname=刘晨 and a Sdept= b Sdept and b Sname<>刘晨 SELECT FROM Student WHERE Sdept IN (SELECT Sde pt FROM Student WHERE Sname=刘晨) and Sname<>刘晨 步骤:先找出刘晨对应的院系,再通过院系找其余学生 MySQL数据库应用》http:/mysq!xg.hactcm.edu.cn 第10页《MySQL数据库应用》 http://mysql.xg.hactcm.edu.cn/ 第 10 页 案例：查询与“刘晨”在一个系学习的学生。 SELECT b.* FROM Student a,student b WHERE a.Sname=‘刘晨’ and a.Sdept= b.Sdept and b.Sname<>‘刘晨' SELECT * FROM Student WHERE Sdept IN (SELECT Sdept FROM Student WHERE sname= ‘刘晨') and Sname<>‘刘晨' 步骤：先找出刘晨对应的院系，再通过院系找其余学生