RBC interview question

what is left-join in SQL