99语法表连接

select a.id from student a join score b on a.id =b.studentid join course c on b.courseid=c.id join teacher d on c.teacherid=d.id where d.name =‘冯英子老师’ order by a.id

表与表之间进行表连接 ：
前一张表后一张表 的 关联字段进行连接

		join 后写表名 on 写连接条件 
		order by 排序
		group by 分组