例句:
select <select_list>
from
<left_table> <join_type>
JOIN <right_table> on <join_condition>
where <where_conditon>
group by <group_by_list>
having <having_condition>
order by <order_by_condition>
limit <limit_number>
执行顺序为:
from <left_table>
on <join_condition>
<join_type> JOIN <rgiht_type>
where <where_condition>
group by <group_by_list>
having <having_condition>
select <select_list>
order by <order_by_condition>
limit <limit_number>