一张图让你明白各种join

http://stackoverflow.com/questions/38549/difference-between-inner-and-outer-joins

sql joins