SQL的书写顺序和执行顺序

左书写顺序，右注释为执行顺序

--SQL查询语句的顺序
SELECT								--7
DISTINCT (select_field)				--8
FROM (table)						--1
(join_type) JOIN (table)			--3
ON (join_condition)					--2
WHERE (where_condition)				--4
GROUP BY (group_by_field)			--5
HAVING (having_condition)			--6
ORDER BY (order_by_field)			--9
LIMIT (limit_number)				--10