title: Mysql : Get participants list of each conversation
body: <p>I have 2 tables <code>conversation</code> and <code>participants</code>, I would like to get the list of conversations and participants in each of them. Can I do that in only one query or I have to do 2 queries one for conversation and the second for getting participants for each conversation ?</p>
  
  <p>I tried with</p>
  
  <pre><code>SELECT c.*, (SELECT p.user FROM participants p WHERE p.conversation_id =  c.id ) AS participants 
  FROM `conversation` c
  ORDER BY c.date DESC
  </code></pre>
  
  <p>But i get "error 1242 subquery returns more than 1 rows" and that's normal !</p>