mysql - 更优雅的连接方式？

Question

有没有更优雅的方式来加入拍摄、教学、学生和顾问？我试过这个：

select s.ID
from takes natural join
     student as s join
     advisor as a
     on ID = a.s_ID join
     teaches as t
     on takes.course_id = t.course_id and
        takes.sec_id = t.sec_id and
        takes.semester = t.semester and
        takes.year = t.year
where a.i_ID = t.ID)

标签： mysqlsqljoin