sql92语法
SELECT ..., ...
FROM ..., ..., ...
WHERE 多表的连接条件(+) AND 不包含聚合函数的过滤条件
GROUP BY ..., ...
HAVING 包含聚合函数的过滤条件
ORDER BY ..., ...(ASC/DESC)
LIMIT ..., ...
sql99语法
SELECT ..., ...
FROM ... (LEFT/RIGHT)JOIN ... ON 多表连接条件
JOIN ... ON ...
WHERE 不包含聚合函数的过滤条件
GROUP BY ..., ...
HAVING 包含聚合函数的过滤条件
ORDER BY ..., ...(ASC/DESC)
LIMIT ..., ...
MySQL不支持92语法外连接(+)和99语法外连接(FULL JOIN)