您好，



看看这里：

http://***.com/questions/354070/sql -join-where-clause-vs-on-clause [ ^ ]

http://www.bennadel.com/blog/284-SQL-Optimization-And-ON-Clause-vs-WHERE-Clause.htm [ ^ 一>

What are the differences between Where Clause and On Clause ? Speed, execution, and the use

Hi,

Have a look here:
http://***.com/questions/354070/sql-join-where-clause-vs-on-clause[^]
http://www.bennadel.com/blog/284-SQL-Optimization-And-ON-Clause-vs-WHERE-Clause.htm[^]