有一点不懂
例如下面sql,有2个join
select * from admin a join rolespower b on a.id = b.id join function c on b.f_id = c.f_id
顺序是:
select * from admin a join rolespower b on a.id = b.id join function c on b.f_id = c.f_id
还是:
select * from admin a join rolespower b on a.id = b.id join function c on b.f_id = c.f_id
红色为先执行的。
例如下面sql,有2个join
select * from admin a join rolespower b on a.id = b.id join function c on b.f_id = c.f_id
顺序是:
select * from admin a join rolespower b on a.id = b.id join function c on b.f_id = c.f_id
还是:
select * from admin a join rolespower b on a.id = b.id join function c on b.f_id = c.f_id
红色为先执行的。
第二步:临时表和function c on b.f_id = c.f_id 链接,生成临时表
第三步:查询临时表一些SQL的知识
桥表