title: How to merge two rows with one different field value into one row with concatenated field
body: <p>I have 3 tables with ManyToMany relations, books, authors, author_books. Sometimes in my application book has more than one author, so as a response i would like to show all of the authors separated by comma,
  Here is a code with join to get book title with authors and id=182</p>
  <pre><code>SELECT books.id,books.title,authors.full_name FROM books 
  INNER JOIN author_books ON author_books.book_id = books.id 
  INNER JOIN authors ON authors.id = author_books.author_id 
  WHERE author_books.book_id=182
  </code></pre>
  <p>How from that:</p>
  <p><a href="https://i.stack.imgur.com/yS4oc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yS4oc.png" alt="enter image description here" /></a></p>
  <p>get the result as</p>
  <pre><code>182|Beautiful Creatures|Kami Garcia, Margaret Stohl
  </code></pre>