Inner join two tables

sql

SELECT o.id, u.email, o.status
FROM orders o
INNER JOIN users u ON u.id = o.user_id;

Explanation

`INNER JOIN` excludes rows without a matching parent or child.

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 joins

Return all rows from the left table and matching rows from the right table.

Open In sheetsqlsame section

Count child rows per parent.

Open In sheetsqlsame section

Join a table to itself using aliases.

Open In sheetsqlsame section

Compute an aggregate once and join it back.

Open In sheetsql1 tag match

Return users who have at least one paid order.

Return users who have orders.