Question: what is the difference between outer join and full outer join?
Answer: In outer joins, all the related data from both the tables are combined correctly, plus all the remaining rows from one table. In full outer joins, all data are combined wherever possible.