I've noticed this print out in a number of cubes at work and I think that attests to it's attractiveness and/or usefulness. I don't use most of these join methods but it is a nice complete feeling list with graphic representations and we might expand our join graphics in DB Optimizer to include similar graphics.
See:
http://www.codeproject.com/KB/database/Visual_SQL_Joins.aspx?msg=2919602
It's a beautiful illustration that database are solidly founded on the set theory.
ReplyDeleteYou can found the same tip of diagramm here:
http://en.wikipedia.org/wiki/Set_(mathematics)
When will we get the complement of A in U ;-)
Thanks.
Nico