SQL: JOIN types

A short, tested SQL example for join types. Copy it and adjust the names and paths for your project.

SQL

-- only rows that match in both tables
SELECT o.id, c.name FROM orders o INNER JOIN customers c ON c.id = o.customer_id;

-- all orders, customer may be NULL
SELECT o.id, c.name FROM orders o LEFT JOIN customers c ON c.id = o.customer_id;

Find it in Zest

Search for “sql join types” in Zest and this example appears above the results, with other matches to choose from. Searches stay private.

More SQL examples

SELECT with WHERE and ORDER BY GROUP BY and HAVING INSERT, UPDATE and DELETE CREATE TABLE Create an index Common table expression (WITH)Window function: ROW_NUMBER Upsert (insert or update)

All SQL examples