a companion discussion area for blog.codinghorror.com

A Visual Explanation of SQL Joins


#204

image

Where ‘possible table contents’ is the cross product given A and B.

Cross product gives us everything outside the diagram as well as what is inside. …Within the scope of possible results that is. This is all in a bigger circle. As far as I can see, the model holds. And if it doesn’t? Then we just need another circle to contain the instances where it fails. :wink: