Search⌘ K
AI Features
Home
Courses
Learn SQL

Solution: Meet the JOIN Family

Explore how to use SQL JOINs, especially LEFT JOIN, to work with multiple tables like real-world datasets. Learn to find students without grades by combining tables and filtering unmatched records. Understand aliasing, joining conditions, and filtering criteria to connect data effectively.

We'll cover the following...

Query

SELECT s.id, s.name
FROM students s
LEFT JOIN grades g ON s.id = g.student_id
WHERE g.id IS NULL;

Explanation

This query finds all students who ...