HomeInterview QuestionsSql, Joins, Inner Join

Why can an INNER JOIN return fewer rows than either of the joined tables?

🟢 Easy Conceptual Fresher level
1 Times asked
Jul 2026 Last seen
Jul 2026 First seen

💡 Model Answer

An INNER JOIN returns only the rows that have matching values in both tables. If a row in one table has no corresponding match in the other table, it is excluded from the result set. Therefore, the number of rows in the join can be less than the number of rows in either input table. For example, if Table A has 10 rows and Table B has 8 rows, but only 5 rows have matching keys, the INNER JOIN will return 5 rows.

Sign in to unlock the rest of this answer

This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.

🎤 Get questions like this answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500