INNER JOIN

sql

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

Explanation

Use `INNER JOIN` when you only want records with matching keys in both tables.

Learn the surrounding workflow

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

Same sheet · prioritizing Join types at a glance

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

Open In sheetsqlsame section

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

Open In sheetsqlsame section

Keep all rows from both tables and match where possible.

Open In sheetsqlsame section

Produce the Cartesian product of two tables.

Open In sheetsqlsame section

Prefer primary keys and foreign keys over names or free-form text.

A `WHERE` clause can accidentally turn a left join into an inner join.