Inner join

sql

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

Explanation

See summary for usage details.

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 Querying, Joins, and Aggregation

Fetch a sorted subset of rows.

Open In sheetsqlsame section

Pick one row per group using PostgreSQL's `DISTINCT ON` extension.

Open In sheetsqlsame section

Keep all rows from the left side even when no match exists.

Open In sheetsqlsame section

Extract a text value from a JSONB document.

Open In sheetsqlsame section

Aggregate rows and then filter groups.

Open In sheetsqlsame section

Assign row numbers within each partition.

Open In sheetsqlsame section