Select Code to Download

select a.book
from BookAuthor a, BookAuthor b
where a.author = 'Smith' and b.author = 'Jones'
and a.book = b.book;

select a.book
from BookAuthor a
inner join BookAuthor b
on a.book = b.book
where a.author = 'Smith' and b.author = 'Jones';