Join Condition
noun
say it: “JOYN kun-DISH-un” /dʒɔɪn kənˈdɪʃən/
The rule in ON that says which rows of two tables belong together, usually matching keys.
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;
In a sentence
- “The join condition ON o.CustomerID = c.CustomerID matches each order to its customer.”
Level: Apprentice · More SQL terms at this level
Updated