RIGHT JOIN
The mirror of a left join: keeps every row of the right-hand table.
In more detail
Any right join can be written as a left join by swapping the two tables, which most people find easier to read. SQLite has supported it only since version 3.39.
Related terms
- LEFT JOIN — A join that keeps every row of the left table and adds the matching right-hand rows, or NULLs when there is no match.
- FULL OUTER JOIN — A join that keeps every row from both tables, pairing them where they match and filling NULLs where they do not.
- outer join — A join that also keeps rows with no match, filling the other table's columns with NULL.
Taught in
- What An Outer Join Really Returns — PostgreSQL, Indexing & Relational Data Modeling