Goldman Sachs interview question

How does Left join work?