Cheat Sheet logoCheat Sheet Today
SQL Cheat Sheet/Inner join two tables

Return rows with matches in both tables.

Back to sheetBrowse commands
Sign in to save
Section: Joins

Inner join two tables

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

INNER JOIN returns only matched rows.

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
Left join
Keep all rows from the left table and match rows from the right table.
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