多表查询中查询表先后顺序

根据业务的发起判断，比如
查询学生并返回班级，那么先查询学生表再查询班级表

select students.*, classes.class_name
from students
join classes on students.class_id = classes.class_id;