title: MySQL Query for list of values in a single cell
body: <p>I have three tables in MSQL as shown below:</p>
  
  <p>customer_details: </p>
  
  <pre><code>cust_id     cust_name   Mob_No
  -----------------------------------------
  1           john        9999999999
  2           Rex         1234567890
  </code></pre>
  
  <p>customer_services:</p>
  
  <pre><code>cust_id     service_id
  --------------------------
  1           s1
  2           s2
  1           s2
  </code></pre>
  
  <p>m_service:</p>
  
  <pre><code>service_id  service_name
  ----------------------------
  s1             IT
  s2             VAT
  </code></pre>
  
  <p>I need the result as below:</p>
  
  <pre><code>cust_id     cust_name   service_name
  --------------------------------------------
  1       John        IT, VAT
  2       Rex         VAT
  </code></pre>
  
  <p>I tried as below:</p>
  
  <pre><code>SELECT a.cust_id,a.cust_name, c.service_name 
  FROM customer_details a, customer_service b, m_service c 
  WHERE a.cust_id=b.cust_id AND b.service_id=c.service_id;
  </code></pre>
  
  <p>But I need the service names in the same row. Any help is highly appreciable</p>
  
  <p>Thanks and Regards
  Biswa</p>