[b] (8)SELECT(9)DISTINCT(11) ( 1 ) FROM [left_table] ( 3 ) JOIN ( 2 ) ON ( 4 ) WHERE ( 5 ) GROUP BY ( 6 ) WITH ( 7 ) HAVING ( 10 ) ORDER BY [/b] 这里同时注意数据查询顺序在同等条件下:1.先子查询后父查询;2.从右到左