where t.tname = '张三' ) 6、查询学过“01”并且也学过编号“02”课程的同学的学号、姓名。 SELECT st.sid,st.sname FROM student st JOIN score sc ON sc.sid=st.sid AND sc.cid='01' WHERE st.sid IN (SELECT st2.sid FROM student st2 JOIN score sc2 ON sc2.sid=st2.sid AND sc2.cid...
5、查询没学过“张三”老师课的学生的学号、姓名(重点)