Beginner
Database Management Systems
Q9 / 100
What is the difference between INNER JOIN and LEFT JOIN?
Correct! Well done.
Incorrect.
The correct answer is B) INNER JOIN returns only rows with matches in both tables; LEFT JOIN returns all rows from the left table and matching rows from the right (NULLs for no match)
B
Correct Answer
INNER JOIN returns only rows with matches in both tables; LEFT JOIN returns all rows from the left table and matching rows from the right (NULLs for no match)
Explanation
INNER JOIN: intersection of both tables. LEFT (OUTER) JOIN: all left table rows, with NULLs where no right-table match. Used when you want all records from one table regardless of matches.
Progress
9/100