# OUTER JOIN

How LEFT, RIGHT and FULL outer joins keep unmatched rows from one or both tables, and how to get a full join in MySQL, which has no FULL OUTER JOIN.

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

- Category: SQL
- Level: Journeyman
- Tags: mysql, sql
- Updated: November 3, 2026

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