Pergunta de entrevista da empresa Fidelity Investments

What is the difference between an inner and outer join in SQL?