What rows does a LEFT JOIN return that an INNER JOIN does not?
Answer options
A
Rows from the right table with no match in the left table
B
Rows from the left table with no match in the right table
C
Duplicate rows from both tables
D
Rows where both tables have NULL values
Correct answer: Rows from the left table with no match in the right table
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of SQL is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.