1，查询知识

1.1 sql执行加载顺序

select  (...)
from （表1，表2，...）
join ....
on ...
where ...
group by ...
Having ...
order by ...
limit ...

1.2七种join理论

参考网址—>链接