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