What are the different types of database joins, and in what scenarios would you use an outer join versus an inner join?
