Complete JOIN Clause
Fill in the Blank Easy
Question
Fill in the blank to return only rows that match in both tables:
Code
SELECT * FROM orders
___ JOIN users ON orders.user_id = users.id;
Hint
This join type returns only the intersection of both tables.
Explanation
INNER JOIN returns only rows that have matching values in both tables. Non-matching rows are excluded from the result.
Related Resources
Related Lessons
- Joins
Learn INNER JOIN.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.