Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT authors.name, book.name_book
- FROM authors INNER JOIN book_author ON authors.id_author = book_author.id_author INNER JOIN book ON book_author.id_book = book.id_book
- WHERE book_author.id_book IN (
- SELECT book.id_book
- FROM book INNER JOIN book_author ON book.id_book = book_author.id_book INNER JOIN authors ON book_author.id_author = authors.id_author
- GROUP BY book_author.id_book
- HAVING COUNT(book_author.id_author) > 1
- )
- ORDER BY book_author.id_book
Add Comment
Please, Sign In to add comment