In the following post, innerjoin = where = join
Http://baike.360.cn/4241488/12057813.html
Http://z.baidu.com/question/46996912.html? SI = 1
The connection statement used in the WHERE clause is called a recessive connection in the database language. Inner join ...... The connection generated by the on clause is called an explicit connection. (Other join parameters are also explicit connections.) There is no essential difference between the connection relationship between where and inner join, and the result is the same. But! Recessive connections have been gradually eliminated with the standardization and development of the database language, and the new database language has basically abandoned recessive connections, all of which adopt explicit connections.
Http://www.cnblogs.com/huangzhenwu/archive/2007/03/06/665557.html
I tested it. Inner join and where queries are not much slow, but left join and right join are much faster than inner join and where.
In the following post, left Outer Join = left join
Http://topic.csdn.net/t/20060105/09/4499011.html
Http://www.javaworld.com.tw/jute/post/view? Bid = 21 & id = 145314 & sty = 3 & age = 0 & TPG = 1 & PPG = 1 #145314