title: grouping one to many relationship in a row
body: <p><code>tableOne</code>:</p>
  
  <pre><code>id  name
  --  ----
  1   A
  2   B
  3   C
  </code></pre>
  
  <p><code>tableTwo</code>:</p>
  
  <pre><code>stuffno  id  stuff  stufftype
  -------  --  -----  ---------
  1        1   D1     D
  2        1   E1     E
  3        1   F1     F
  4        2   D2     D
  5        2   E2     E
  6        2   F2     F
  7        3   D3     D
  8        3   E3     E
  9        3   F3     F
  </code></pre>
  
  <p>Requested result:</p>
  
  <pre><code>name  stuffD  stuffE  stuffF
  ----  ------  ------  ------
  A     D1      E1      F1
  B     D2      E2      F2
  C     D3      E3      F3
  </code></pre>
  
  <p>How do I do that in one SQL query?</p>