title: SQL: 3 tables (book, author, book_author)
body: <p>I have 3 tables in my MySQL database which have the following structures:</p>
  
  <p>Book table:</p>
  
  <pre><code>     BOOK
  ---------------
  book_id | title
  ---------------
     1    |   A
     2    |   B
  </code></pre>
  
  <p>Author table:</p>
  
  <pre><code>     AUTHOR
  ----------------
  author_id | name
  ----------------
       1    | John
       2    | Bush
       3    | Alex
       4    | Bob
  </code></pre>
  
  <p>And then I have a junction-table that establishes a many-to-many relationship between the tables book and author, which means that a book can be written by many authors (coauthored, that is) and an author can have many books he or she has penned.</p>
  
  <pre><code>    BOOK_AUTHOR
  --------------------
  book_id |  author_id
  --------------------
     1    |     1
     1    |     2
     1    |     3
     1    |     4
     2    |     3
     2    |     4
  </code></pre>
  
  <p>Is it possible by means of SQL or MySQL to get the DBMS to output something like this:</p>
  
  <pre><code> book_id |  title  |       authors
  ------------------------------------------
      1    |    A    | John, Bush, Alex, Bob
      2    |    B    | Alex, Bob
  </code></pre>
  
  <p>The authors row in the output is a concatenation of all the authors associated with a particular book.</p>