Electronic Arts interview question

Explain how SQL left join works