An Inner Join just returns the overlapping areas of the Venn Diagram. A Left Outer Join returns all the the data from the left circle, and it includes the overlapping information from the right circle ...