sql left out join http://hi.baidu.com/llscompazz/blog/item/dc5e23d9ce2b62eb39012fb4.html http://hi.baidu.com/llscompazz/blog/item/dc5e23d9ce2b62eb39012fb4.html