INNER JOIN

Join two tables on a matching column

Join

SQL

SELECT u.name, o.total
FROM users u
INNER JOIN orders o ON u.id = o.user_id;

What each clause does

INNER JOIN returns only rows where both tables have matching values. ON defines the join condition (u.id = o.user_id).

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE INSERT INTO UPDATE SET DELETE FROM LEFT JOIN GROUP BY ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET