Question d’entretien chez Electronic Arts

Explain how SQL left join works