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.

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.