PostgreSQL SyntaxLesson 31Free preview

PostgreSQL INNER JOIN

This lesson is part of PostgreSQL · All levels

Summary

INNER JOIN only returns the row that has a match on both tables according to the join condition. So the line without a pair on either side will be deviated from the result. Writing JOIN without the additional word means INNER JOIN by default.

Key points

INNER JOIN displays only the corresponding rows on both tables.
JOIN without the other embellishments means INNER JOIN.
The match is determined by the ON condition using the key column.
The results can be filtered again with the WHERE clause.

Full lesson

Code examples and quizzes

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