SQL 练习9

  • 查询学过「张三」老师授课的同学的信息
SELECT Student.* from Student,Teacher,Course,SC WHERE Teacher.TId = Course.TId 
AND Student.SId = SC.SId 
AND Course.CId = SC.CId 
AND Teacher.Tname='张三'

image

posted @ 2021-08-18 17:45  弩哥++  阅读(27)  评论(0)  编辑  收藏  举报