SQL - LEFT and RIGHT JOIN
Which JOIN type keeps all rows from the first (left) table, even if there is no matching row in the second (right) table?
Which JOIN type keeps all rows from the first (left) table, even if there is no matching row in the second (right) table?
easy📝 Conceptual Q11 of 15
Step-by-Step Solution
Solution:
Step 1: Understand LEFT JOIN behavior
LEFT JOIN returns all rows from the first table and matching rows from the second table. If no match, NULLs appear for second table columns.Step 2: Compare with RIGHT JOIN
RIGHT JOIN keeps all rows from the second table, not the first. INNER JOIN only returns matching rows. FULL JOIN returns all rows from both tables.Final Answer:
LEFT JOIN -> Option CQuick Check:
LEFT JOIN keeps all left table rows [OK]
Quick Trick: LEFT JOIN keeps all from first table, RIGHT JOIN from second [OK]
Common Mistakes:
MISTAKES- Confusing LEFT JOIN with RIGHT JOIN
- Thinking INNER JOIN keeps unmatched rows
- Assuming FULL JOIN keeps only one table's rows
Master "LEFT and RIGHT JOIN" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes