📘
SQL Guide
SQL LEFT JOIN
Keep every row from the left table and attach matches when available.
Intermediate lesson
Continue learning for free
You've been reading the Beginner lessons free of charge. Create a free account to unlock Intermediate and Advanced SQL — plus daily tasks, challenges, AI feedback, and progress tracking. No credit card required.