DMI interview question

What is left join in SQL?