Pergunta de entrevista da empresa OpenText

What's the difference between inner and outer join (SQL)?