SQL · Joins and set operations

full outer join

Keeps unmatched rows from both sides. SQLite does not support FULL OUTER JOIN.

sqlRunnable example sql course

Syntax

from a full outer join b on …

Example

Open in the lab

-- PostgreSQL
-- SELECT * FROM a FULL OUTER JOIN b ON a.id = b.id;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.