|< < 42 > >|

Subqueries

Who wrote Cat's Cradle?

Using a join


select name
from author join book using (author_id)
where title = 'Cat''s Cradle'

Using a subquery


select name
from author
where author_id in (
    select author_id 
    from book
    where title = 'Cat''s Cradle'
)

|< < 42 > >|