Pergunta de entrevista da empresa Macquarie Group

Difference between inner and outer join?