Re: Is it collect?

[Phillip Ward]

Correlated Subqueries can be "problematic".
Better to use joins between the tables.

select *
from table1 t1 
inner join table2 t2 on t1.id = t2.id 
where t2.name = 'John'

Regards, Phill W.