Left join to keep unmatched parent rows

sql

SELECT u.id, u.email, o.id AS order_id
FROM users u
LEFT JOIN orders o ON o.user_id = u.id;

Explanation

Rows from `users` remain even when there is no matching row in `orders`.

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 rows where both tables match.

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.