PostgreSQL SyntaxLesson 34Free preview

PostgreSQL FULL JOIN

This lesson is part of PostgreSQL · All levels

Summary

FULL JOIN or FULL OUTER JOIN retains the entire row of both tables, whether matching or not. The value that has no pair is filled on the opposite side. This pattern is very useful for comparing two data sources and finding the differences between them.

Key points

FULL JOIN displays all the rows of both tables.
The opposite column is filled when no pair is found.
It's perfect for comparing two data sources.
Detection of incompatibility with IS on either side.

Full lesson

Code examples and quizzes

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