MySQL + SQL · Lesson 67

INNER JOIN in MySQL

INNER JOIN

INNER JOIN returns only the rows that have a match in BOTH tables. Unmatched rows are dropped.

Example

SELECT s.name, c.class_name
FROM students s
INNER JOIN classes c ON s.class_id = c.class_id;
A student with a class_id that has no matching class is NOT shown.

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.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.