OpenText interview question

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