Databases · Junior · Question 21 of 75

What does an `INNER JOIN` return?

✓Correct answer: Only rows that have a match in both tables
2All rows from both tables
3All rows from the left table, matched or not

Explanation

JOIN without a keyword means INNER JOIN. Users without orders, and orders without users, are not in the result.

Further reading

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.