INNER JOIN
noun
say it: “IN-er JOYN” /ˈɪnər dʒɔɪn/
A join that returns only the rows that have a match in both tables.
What is INNER JOIN in a relational database?
INNER JOIN — A join returning only row combinations that satisfy its join condition.
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 INNER JOIN left out products with no category.”
Level: Apprentice · More SQL terms at this level
Updated