The quote “One Picture Worth Ten Thousand Words” could not be more appropriate for SQL joins. This picture helps me think about the kind of join I want for any situation. The correct join makes the results correct. The wrong join may look correct but you could be missing data.
Good Site for more information.