Left join basically gives you the results of an inner join plus the unmatched rows. You should only use left join when needed because otherwise your results may contain unwanted rows.