# Learn SQL: Full Join ![rw-book-cover](https://api.boot.dev/v1/static/course_image/learn-sql) ## Metadata - Author: [[boot.dev]] - Full Title: Learn SQL: Full Join - Category: #articles - Summary: Learn the fundamentals of Structured Query Language (SQL), the most popular way to interact with databases like MySQL, PostgreSQL, and SQLite. - URL: https://www.boot.dev/lessons/73801fcd-9a3d-462b-9064-cf450dc1d00e ## Highlights - A `FULL JOIN` combines the result set of the `LEFT JOIN` and `RIGHT JOIN` commands. It returns *all* records from both `table_a` and `table_b` regardless of whether or not they have matches. ([View Highlight](https://read.readwise.io/read/01kegak4jevwrbrej7gx7zywdp))