title: [SQL]One selected column and two values, select them in a row
body: <p>I have three tables <a href="http://i.stack.imgur.com/pqaak.png" rel="nofollow">here</a> :</p>
  
  <p>With this select, </p>
  
  <pre><code>SELECT a.id, a.title, at.places, at.color FROM activityTypes as at inner join activitiesCombination as ac on at.id = ac.activityTypeId inner join activities as a on a.id = ac.activityId
  </code></pre>
  
  <p>I'm able to retrieve informations like <a href="http://i.stack.imgur.com/61unD.png" rel="nofollow">this</a> :</p>
  
  <p>I would like to have all of these informations in this format :</p>
  
  <p>id, title, color1, color2</p>
  
  <p>Does you have the solution, knowing that many time there wont have two activity types for an activity ?</p>
  
  <p>Thanks</p>