SQL TutorialLesson 27Free preview

SQL Inner Join

This lesson is part of SQL · All levels

Summary

INNER JOIN returns only the row that has a match on both joined tables. The unpaired line on one of the tables will be filtered out. This is the most common type of joint used because it produces a truly relational relationship.

Key points

INNER JOIN produces a matching line segment on both tables.
ON indicates the linking column between tables.
Writing JOIN without INNER means staying INNER JOIN because it's default.
It can combine more than two tables in a row.
A line without an automatic partner doesn't come up.

Full lesson

Code examples and quizzes

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