Here is a pretty nice illustration of the join types. (cool blog too...)

It's one of those "hard to explain with words" things I think. It is easier for me to visualize it.

__________________
-- Bill
"Why is it drug addicts and computer aficionados are both called users?" -Clifford Stoll