sql语句中left join、inner join中的on与where的区别 where比on的效率要低 http://www.cnblogs.com/hgwy/articles/1691689.html