title: mysql query with GROUP_CONCAT
body: <p>I have two tables. Suppose <code>business_type_master</code> and <code>contact_master</code>. The primary key of <code>business_type_master</code> is entered in <code>contact_master</code> table in comma separated value like <code>2,3,4</code>.</p>
  
  <p>Now I am going to join those tables and using <code>GROUP_CONCAT</code>. But it does not return the desired output. My output will be like this</p>
  
  <ul>
  <li><code>business_type_id</code> ==> <code>2,3,4</code></li>
  <li><code>business_name</code>  ==> <code>A,B,C</code></li>
  </ul>
  
  <p>But my output is like below</p>
  
  <ul>
  <li><code>business_type_id</code> ==> <code>2,3,4</code></li>
  <li><code>business_name</code> ==> <code>A</code></li>
  </ul>
  
  <p>My query is </p>
  
  <pre><code>SELECT cm.contact_id, cm.full_name, 
    GROUP_CONCAT(cm.business_id) AS business_type_id,             
    GROUP_CONCAT(btm.business_type_name) AS business_type_name 
  FROM contact_master AS cm           
  JOIN business_type_master AS btm ON cm.business_id = btm.business_type_id 
  GROUP BY cm.contact_id
  </code></pre>
  
  <p>Can anybody help?</p>