摘要： Assuming you're joining on columns with no duplicates, which is by far the most 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 A and B gives the results of A union B, i.e. the outer parts of a venn diagram u 阅读全文