SELECT语句的逻辑处理顺序
5 SELECT <column list>
1 FROM <source object list>
1.1 FROM <left source object> <join type>
JOIN <right source object> ON <on predicates>
2 WHERE <where predicates>
3 GROUP BY <group by expression(s)>
4 HAVING <having predicates>
6 ORDER BY <order by list>
从上面可以看出SELECT执行不同于其它语言,是从FROM开始的,标记为1.1的FROM子句表示FROM的不同语法。