|< < 47 > >|
A correlated subquery is a subquery which depends on values from the surrounding query. E.g. select name from author a where exists ( select * from book b where year between 1960 and 1969 and b.author_id = a.author_id )
select name from author a where exists ( select * from book b where year between 1960 and 1969 and b.author_id = a.author_id )