JOIN
noun
say it: “JOYN” /dʒɔɪn/
Combining rows from two tables into one result, matching them on related columns.
What is JOIN in a relational database?
JOIN — A query operation combining related rows from two table expressions.
SELECT customer.email, purchase_order.order_id
FROM customer
INNER JOIN purchase_order
ON purchase_order.customer_id = customer.customer_id;
In a sentence
- “A JOIN on CustomerID put each order beside its customer's name.”
Level: Apprentice · More SQL terms at this level
Updated