# OUTER JOIN

LEFT JOIN keeps every row of the first table, matched or not; RIGHT JOIN keeps every row of the second; FULL OUTER JOIN keeps both. Rows with no match get NULL, which also lets you find what's missing.

![Cheat sheet: OUTER JOIN](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/bebe553cea21447996dfc4cd634c74c0.webp)

- Category: SQL
- Level: Journeyman
- Tags: FULL OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, sql, t-sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/joining-tables-in-t-sql-outer-join-cheat-sheet