Which can now be efficiently optimized as an inner join query.

• 该查询现在可以作为内部连接查询进行有效的优化。