Current lesson | Lesson 20/24

LEFT JOIN and RIGHT JOIN in a One-to-One Relationship

From ER Diagram to MySQL: Your Complete Learning Path 0%
Let's wrap up the One-to-One relationship section with LEFT JOIN and RIGHT JOIN. I'll show you how to query the two tables to extract records with and without a match, how to interpret NULL values in the results, and when each join type returns exactly what you need.
Instructor
Up next SELECT, Projection, AND/OR, ORDER BY and Date Filtering with BETWEEN