LEFT JOIN

Get all records from the left table.

Example

-- LEFT JOIN includes users even if they have no orders
SELECT u.name, o.id AS order_id FROM users u LEFT JOIN orders o ON u.id = o.user_id;