不会有大多数人都和我一样的认为,是先进行的Where 剔除结果集,再进行Join的吧
SQL server 2014 逻辑执行标准:
https://msdn.microsoft.com/en-us/library/ms189499(v=sql.120).aspx
FROM
-
FROM
-
ON
-
JOIN
-
WHERE
-
GROUP BY
-
WITH CUBE or WITH ROLLUP
-
HAVING
-
SELECT
-
DISTINCT
-
ORDER BY
-
TOP
Oracle 12c 逻辑执行标准
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10002.htm