What is the difference between “INNER JOIN” and “OUTER JOIN”?
Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in? 2 27 Assuming you’re joining on columns with no duplicates, which is a very common case: An inner join of A and B gives the result of A intersect B, i.e. the inner part of a Venn diagram intersection. An outer join of … Read more