RBC Interview Question

what is left-join in SQL