select * from a join b
on a.id = b.id and b.is_del = 0
where a.is_del = 0
on 先过滤,对b生效
where 对 join后的结果 生效
优先级 on > where
I suspect “on” filter table,then linked
select * from a join b
on a.id = b.id and b.is_del = 0
where a.is_del = 0
on 先过滤,对b生效
where 对 join后的结果 生效
优先级 on > where
I suspect “on” filter table,then linked