LEFT JOIN Behavior
Multiple Choice Easy
Question
What does a LEFT JOIN return for non-matching rows?
Hint
LEFT JOIN always keeps all rows from the left table.
Explanation
LEFT JOIN returns all rows from the left table. For rows with no match in the right table, the right table's columns are filled with NULL. This is useful for keeping all left records.
Related Resources
Related Lessons
- Joins
Learn join types.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.