Sanofi interview question

What is a left join in sql?