【简答题】查询学过「张三」老师授课的同学的信息
已帮助 人
回答
共1条回复-
select s.* from Student as s,SC,course,Teacher where s.Sid=SC.Sid and Course.Cid=SC.Cid and Teacher.Tid=Course.Tid and Teacher.Tname = ' 张三 ' group by s.Sid