MySQL SQLLesson 29Free preview

MySQL INNER JOIN

This lesson is part of MySQL · All levels

Summary

INNER JOIN only displays the row that has matching pairs on both tables. If a row in the left table does not find a pair in the right table (or vice versa), the row does not appear at all. This type of join is most commonly used when you just want data that's really interrelated, like orders coming from a subscriber who's still registered.

Key points

INNER JOIN returns only the matching lines on both tables
The line without the automatic pair is filtered out of the result
By default, just writing JOIN means INNER JOIN
Can be paired with an extra WHERE to filter the combined results

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.