Join Three Tables

Joining Multiple Tables

Three-Table Join

SELECT s.name, c.course_name, t.teacher_name
FROM students s
JOIN enrollments e ON s.id = e.student_id
JOIN courses c ON e.course_id = c.id
JOIN teachers t ON c.teacher_id = t.id;

How it Works

Summary

• Chain multiple JOIN ... ON clauses, each linking on a common key.
• Use table aliases (s, c, t) to keep the query short and clear.

कई Tables Join करना

तीन-Table Join

SELECT s.name, c.course_name, t.teacher_name
FROM students s
JOIN enrollments e ON s.id = e.student_id
JOIN courses c ON e.course_id = c.id
JOIN teachers t ON c.teacher_id = t.id;

कैसे काम करता है

सारांश

• कई JOIN ... ON clauses chain करें, हर एक common key पर।
• Query छोटी और साफ रखने को table aliases (s, c, t) use करें।