知识点:sql执行顺序
from (去加载2个表 ) -> join -> on -> where -> group by->select 普通字段
聚合函数:count,sum -> having -> distinct -> order by -> limit
知识点:left join on和where的条件过滤区别
(以下只适用于left join,right join,full join,不适合inner join)
1、left join where + 基表过滤条件:先对基表执行过滤,然后进行left join;
2、left join where + 被关联表过滤条件:先执行left join,然后执行关联表的过滤条件;
3、left join on+基表过滤条件:满足过滤的基表记录执行left join,不满足的基表记录后面补null,然后两集合并一起;
4、left join on+被关联表过滤条件:先执行被关联表的过滤条件,然后执行left join;
面试题:表A数据在什么情况下相同,什么情况下不同?两种写法有什么区别?
<--sql1:where过滤表B-->
SELECT
a.*,
b.*
FROM
acl_class AS a
LEFT JOIN acl_object_identity AS b ON a.id = b.object_id_class
WHERE