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;Ctrl+Enter to submit