title: MYSQL Distinct and Show Group Values
body: <p>Is this possible in mysql query.. </p>
  
  <p>I want to select distinct client name, group by client name..</p>
  
  <p>then show the values in the group_name..</p>
  
  <pre><code>table 1
  
  id    client_name   Group_id     
  ------------------------------
  1     IBM               1
  2     DELL              1   
  3     DELL              2
  4     MICROSOFT         3 
  
  table 2
  
  id    group_name
  ------------------
  1     Group1      
  2     Group2     
  3     Group3  
  </code></pre>
  
  <p>I need a result like this</p>
  
  <pre><code>client_name      merge_group   
  -------------------------
  IBM                Group1
  DELL               Group1, Group2
  MICROSOFT          Group3
  </code></pre>