Skip
Arish's avatar

183. Joining Multiple Tables


Three or More Tables

sql
1SELECT s.name, c.course_name, i.instructor_name
2FROM students s
3JOIN courses c ON s.course_id = c.id
4JOIN instructors i ON c.instructor_id = i.id;

Chain JOINs together.