Question: what is difference between full outer join and inner join?
Answer: Inner joins result in the overlapping part of the Venn diagram of two datasets, whilst for full outer joins the outer parts of the Venn diagram will also be returned. For an inner join, only the rows that both tables have in common are returned. However, for a full outer join, all rows from both tables are returned.