LEFT JOIN and RIGHT JOIN in a One-to-One Relationship
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.