LEFT JOIN1 / 10
A Left Join keeps all rows from the first table (or "left" table) and shows results from the second table (or "right" table) only where there's a match. If there's no match, it shows null for the values in the joined row. Try typing:
SELECT *
FROM cars
LEFT JOIN owners
ON cars.car_id = owners.car_id;Table cars
| car_id | make | model | year |
|---|---|---|---|
| 1 | Toyota | Camry | 2020 |
| 2 | Honda | Civic | 2019 |
| 3 | Ford | Mustang | 2021 |
| 4 | Tesla | Model 3 | 2022 |
| 5 | Chevrolet | Impala | 2018 |
Table owners
| owner_id | car_id | owner_name |
|---|---|---|
| 1 | 1 | Alice |
| 2 | 2 | Bob |
| 3 | 4 | Carlos |
No key for < or > on your keyboard? Use these:
Ctrl+Enter to submit
LEFT JOIN - Free SQL Practice Online
Practise LEFT JOIN with 10 free, interactive SQL exercises. You type real queries into your browser and get instant feedback on every answer - no database setup, no install, and no signup. It is a fast, hands-on way to learn SQL online and build query skills you can use at work.