I have a question about many to many relationships in Oracle, and a way to join them in a query.
I've pasted my (textbook) example along with some inserts to make it clear. The query I want to build needs to extract books along with their respective authors and other authors that have no book yet.
I've been working with:
SELECT a.name, a.surname, b.book_title FROM books b, authors a, publish p WHERE b.book_id = p.book_id(+) AND a.author_id = p.author_id;
However, that fails to do the trick.