Joins Explained Visually

INNER vs LEFT JOIN

An INNER JOIN keeps only matches; a LEFT JOIN keeps every left row, filling gaps with NULL.

SELECT u.name, c.title
FROM users u
LEFT JOIN enrollments e ON e.user_id = u.id
LEFT JOIN courses c ON c.id = e.course_id;

Reach for LEFT JOIN when you still want users who haven't enrolled.