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