Technical documentation being what it is, I've never found the explanation of joins in the SQL Books Online very clear, without actually going and playing with the dummy data and the different types of joins.
Now Jeff Atwood of Coding Horror fame has written the simplest explanation of join I've seen.