I don't use SQL very often, but I've found Jeff Atwood's explanation using Venn diagrams sticks in my memory pretty well:

http://www.codinghorror.com/blog/2007/10/a-visual-explanatio...