SELECT books_authors.author_id,book_title,author_name
FROM books_authors
INNER JOIN authors ON authors.author_id=books_authors.author_id
INNER JOIN books ON books.book_id=books_authors.book_id
ORDER BY books_authors.book_id ASC