Join Condition

The predicate deciding which rows from joined sources match.

What is Join Condition in a relational database?

Join Condition — The predicate deciding which rows from joined sources match.

SELECT customer.email, purchase_order.order_id
FROM customer
INNER JOIN purchase_order
    ON purchase_order.customer_id = customer.customer_id;

Level: Apprentice · More Database terms at this level

Updated