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.