title: GROUP_CONCAT with LEFT OUTER JOIN of two tables
body: <pre><code>SELECT table1.value, table2.additionalinfo
  FROM table1
  LEFT OUTER JOIN table2
  ON table1.ID=table2.ID
  </code></pre>
  
  <p>I try to output something like this</p>
  
  <pre><code>Value   AdditionalInfo
  blah    something, somethingelse, more
  blah2   NULL
  blah3   stuff
  </code></pre>
  
  <p>but I get </p>
  
  <pre><code>Value   AdditionalInfo
  blah    something
  blah    somethingelse
  blah    more
  blah2   NULL
  blah3   stuff
  </code></pre>
  
  <p>I tried to use <code>GROUP_CONCAT</code> and <code>GROUP_CONCAT(DISTINCT)</code></p>
  
  <pre><code>SELECT GROUP_CONCAT(table1.value), table2.additionalinfo
  FROM table1
  left outer JOIN table2
  ON table1.ID=table2.ID ORDER BY table1.value
  </code></pre>
  
  <p>When I add <code>GROUP_CONCAT</code> and <code>ORDER BY table1.value</code> it lists just one additionalinfo per value but none of the values and doesn't get the repeated additionalinfos. I moved the order by all around to no avail.</p>