LEFT JOIN

Include all left table rows, even without matches

Join

SQL

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

What each clause does

LEFT JOIN returns all rows from the left table (users) plus matching rows from the right. Non-matches get NULL for right-side columns.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

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