What should left join accomplish?

Thanks in advance.