写法1: 结果如图1SELECT * from student
INNER JOIN score on student.s=score.s
inner join course on score.c=course.c
inner join teacher on course.t=teacher.t
where teacher.tname="张三"
写法2:结果如图2
select a.* from student a
INNER JOIN score b on a.s=b.s
INNER JOIN course c on b.c=c.c
INNER JOIN teacher d ON c.t=d.t
where d.tname="张三"