Cheat Sheet logoCheat Sheet Today
SQL Cheat Sheet/Left join

Keep all rows from the left table and match rows from the right table.

Back to sheetBrowse commands
Sign in to save
Section: Joins

Left join

sql
sql
SELECT c.customer_id, o.order_id
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.customer_id;
Explanation

Rows without a match on the right side get NULLs for right-side columns.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Joins
Inner join two tables
Return rows with matches in both tables.
OpenIn sheetsqlsame section
Right join
Keep all rows from the right table.
OpenIn sheetsqlsame section
Full outer join
Return matched and unmatched rows from both tables.
OpenIn sheetsqlsame section
Self join
Join a table to itself.
OpenIn sheetsqlsame section
Cross join
Return the Cartesian product of two sets.
OpenIn sheetsqlsame section
Select all columns
Return all columns from a table.
OpenIn sheetsql