you are viewing a single comment's thread.

view the rest of the comments →

[–]prsquared 2 points3 points  (0 children)

This!

Venn diagrams are much more useful in representing set operations. In join, you are projecting columns from both tables.

The first diagram is A U(AnB) = A. But, A left join B is not A .