LEFT JOIN keeps all rows of the left table, with the right-hand columns filled with NULL when there is no match. It is used to keep items with no counterpart, such as customers with no orders, and to count or detect their absence.
Example
SELECT c.nom, COUNT(o.id)
FROM clients c LEFT JOIN commandes o ON o.client_id = c.id
GROUP BY c.nom;