PIMCO interview question

What is Left Join / Outer Join