Outer joins
Keeping the books with unknown authors (attempt 1)
Find books with authors, without authors, combine using UNION
select b.title, a.name
from book b join author a using (author_id)
union
select b.title, NULL
from book b
where b.author_id is NULL
|