Electronic Arts Interview Question

Explain how SQL left join works