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.