① select 字段名 ② from 表1 inner|left|right join 表2 on 表1 与表2 的关系… ③ where ... ④ group by ... having ... ⑤ order by ⑥ limit start, count;