逻辑查询处理的步骤和连接查询

逻辑查询处理的步骤序号
(8) select (9) distinct (11) <top_specification> <select_list>
(1) from <left_table>
(3)   <join_type> join <right_table>
(2)     on <join_condition>    
(4) where <where_condition>
(5) group by <group_by_list> 
(6) with {cube | rollup}
(7) having <having_condition>
(10)order by <order_by_list>

from 后的四种表运算符
(J) <left_table_expression>
     <join_type> join <right_table_expression>
      on <join_condition>
(A) <left_table_expression>
     {cross | outer} apply <right_table_expression>

(p) <left_table_expression>
     pivot(<aggregate_func(<expression>)> for
      <source_col> in (<target_col_list>))
     as <result_table_alias>
<u> <left_table_expression>
      unpivot ( <target_values_col> for
       <target_name_col> in (source_col_list))
       as <result_table_alias>