Databases & SQL

Inner Join

/ˈɪnər dʒɔɪn/

Definition

A SQL JOIN returning only rows where the join condition matches in both tables.

Example in context

"INNER JOIN orders ON users.id = orders.user_id returns only users who have placed at least one order."

Related terms

Practice this term

Master Inner Join in context by working through exercises in the Databases & SQL module. You'll see the term used in real engineering scenarios with multiple-choice, fill-in-the-blank, and matching drills.

Frequently Asked Questions

What does "Inner Join" mean?

A SQL JOIN returning only rows where the join condition matches in both tables.

How do you pronounce "Inner Join"?

"Inner Join" is pronounced /ˈɪnər dʒɔɪn/.

Can you use "Inner Join" in a sentence?

"INNER JOIN orders ON users.id = orders.user_id returns only users who have placed at least one order."