Join = select a.a from a, b where a.aa = b.aa
lookup = select a.a from a where exists (select 1 from b where a.aa=b.aa)
12-21
1714
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-24
11-24
Join = select a.a from a, b where a.aa = b.aa
lookup = select a.a from a where exists (select 1 from b where a.aa=b.aa)