This is can be done through creating drive table of author_books table and then joining the both. First part of the query will find the authors with multiple books. Then join the drive table to that on ab_author_id. Take the example below:

SELECT ab_1.ab_author_id, ab_1.ab_book_id
FROM author_books ab_1
INNER JOIN
(

     SELECT ab_author_id, COUNT( ab_book_id )
     FROM author_books ab_2
     GROUP BY ab_author_id
     HAVING COUNT( ab_book_id ) >1

) AS ab_3 ON ab_1.ab_author_id = ab_3.ab_author_id;

Posted in: MySQL

Related FAQ's

Marius Ion ANGEL HOT SOFT LLC (800) 316-7677