|< < 46 > >|

Correlated subqueries

The subqueries we've seen so far have been self-contained. They can be evaluated out of context. E.g.
select name from author where author_id in ( select author_id from book where year between 1960 and 1969 )

|< < 46 > >|