Amazon interview question

Difference between outer join/inner join, where/having.