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