来自外部 select 的列在子选择中可见.

Columns from outer select are visible in sub-select.

您的查询相当于:

select * 
from test1 
where test1.id1 in (select test1.id1 from test2);