Join with additional predicate

sql

SELECT o.order_id, s.status
FROM orders o
JOIN shipments s
  ON s.order_id = o.order_id
 AND s.status = 'delivered';

Explanation

Predicates in the ON clause affect join matching behavior.

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 Conditions and Filters

Pre-aggregate a table and join the result.

Open In sheetsqlsame section

Use LEFT JOIN plus NULL filtering to find unmatched rows.

Open In sheetsqlsame section

Filter rows based on results from another query.

Return rows when a related row exists.

Return a single value from a nested query.

Return rows with no related matches.