Question: what is the difference between full outer join and 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.