Model N interview question

Please describe a left join in SQL.