INNER JOIN in MySQL

INNER JOIN

Example

SELECT s.name, c.class_name
FROM students s
INNER JOIN classes c ON s.class_id = c.class_id;

Table Aliases

students s gives the table a short alias s, so you write s.name instead of students.name.

Summary

• INNER JOIN = only rows matching in both tables.
• Use ON to state the matching condition; aliases shorten queries.

INNER JOIN

Example

SELECT s.name, c.class_name
FROM students s
INNER JOIN classes c ON s.class_id = c.class_id;

Table Aliases

students s table को छोटा alias s देता है, तो students.name की जगह s.name लिखते हैं।

सारांश

• INNER JOIN = सिर्फ दोनों tables में matching rows।
• matching condition के लिए ON use करें; aliases queries छोटी करते हैं।