常见通用Join查询

SQL执行顺序

手写

SELECT DISTINCT < select_list >
FROM < left_table> < join_type >	
JOIN < right_table > 
ON < join_condition >
WHERE < where_condition >	
GROUP BY < group_by_list >	
HAVING < having_condition >	
ORDER BY < order_by_condition >	
LIMIT < limit_number >

机读：首先保障数据的完整性，连接所有数据，然后在从所有的数据中where/having筛选，再选择字段排序，查询，分组，限制数据，然后输出。

FROM < left_table>
ON < join_condition > < join_type >
JOIN < right_table >
WHERE < where_condition >
GROUP BY < group_by_list >
HAVING < having_condition >	
SELECT DISTINCT < select_list >
ORDER BY < order_by_condition >
LIMIT < limit_number >

Join图