Do you know LEFT JOIN in SQL query?
Utilisateur anonyme
A left join will join a row and the joined columns will be null if there is no match to the ON criteria. This is in contrast to an inner join which will omit a row entirely when the ON criteria isn't met.