Pregunta de entrevista de Amazon

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