1. http://www.cnblogs.com/mr-wid/archive/2013/05/09/3068229.html#d2 2.http://www.w3school.com.cn/sql/sql_alias.asp