title: sql query to list all the items in a group in one record
body: <p>I need to write a query that will return to me all the items in a group in one record, separated by commas,from two tables, example result below,</p>
  
  <p>Items table:</p>
  
  <pre><code>--------------------
  Name    |  Group_ID
  --------------------
  item1   |  1
  item2   |  1
  item3   |  3    
  </code></pre>
  
  <p>Group table:</p>
  
  <pre><code>--------------------
  ID    |  Name
  --------------------
   1    |  Group1
   3    |  Group3     
  </code></pre>
  
  <p>Result i'm looking for:</p>
  
  <pre><code>------------------------------
  GId  |  Items  
  ------------------------------
   1   |  item1, item2
   3   |  item3      
  </code></pre>