title: Can not determine what the WHERE clause should be
body: <p>I'm stuck with creating a MySQL query. Below is my database structure.</p>
  
  <p><code>authors</code> (author_id and author_name)</p>
  
  <p><code>books</code> (book_id and book_title)</p>
  
  <p><code>books_authors</code> is the link table (book_id and author_id)</p>
  
  <p>Result of all books and authors: </p>
  
  <p><img src="https://i.stack.imgur.com/VLzXn.png" alt="img"></p>
  
  <p>I need to get all the books for certain author, but if a book has 2 authors the second one must be displayed also. For example the book "Good Omens" with book_id=2 has two authors. When I run the query I get the books for the author_id=1 but I can not include the second author - "Neil Gaiman" in the result. The query is:</p>
  
  <pre><code>SELECT * FROM books 
     LEFT JOIN books_authors 
         ON books.book_id=books_authors.book_id 
     LEFT JOIN authors 
         ON books_authors.author_id=authors.author_id 
  WHERE books_authors.author_id=1
  </code></pre>
  
  <p>And below is the result:</p>
  
  <p><img src="https://i.stack.imgur.com/PypqZ.png" alt=""></p>