title: Group by on table, list all of one attribute for each of another attribute
body: <p>I'm attempting to group this data by name so that instead of current query output giving me:</p>
  
  <pre><code>Name                       Number
  Nice guy                   1
  Nice guy                   2
  Nice guy                   4
  Nice guy                   5
  Nice guy                   6
  Nice guy                   7
  Nice guy                   8
  Nice guy                   9
  Nice guy                   10
  Nice guy                   11
  Nice guy                   12
  Frank                      3
  Frank                      4
  </code></pre>
  
  <p>I would get this:</p>
  
  <pre><code>Name       Number
  Nice guy   1,2,4,...
  Frank      3,4
  </code></pre>
  
  <p>Here is my current query:</p>
  
  <pre><code>select distinct name, number
  from patterns,numbers,people
  where patterns.index=numbers.index
  AND patterns.id=people.id
  order by name, charge;
  </code></pre>
  
  <p>What I have tried is this, but it fails:</p>
  
  <pre><code>select distinct name, number
  from patterns,numbers,people
  where patterns.index=numbers.index
  AND patterns.id=people.id
  group by name
  order by name, number;
  </code></pre>
  
  <p>Any help would be greatly appreciated!</p>