title: Getting Value in Subquery
body: <p>I donot want <strong>r.reguser_id as test</strong> column in results, And if i remove this Column from Select statement then i am having problem in <strong>WHERE  bu.business_id = r.reguser_id</strong> and got an error of <strong>More then 1 row Returns.</strong></p>
  
  <pre><code>SELECT r.reguser_name ,  r.reguser_id as test,
  
  (Select r.reguser_id as c, GROUP_CONCAT(i.industry_name) as Industry
  
  From reguser r inner JOIN business_industry bu ON r.reguser_id = bu.business_id  join industry i ON bu.industry_id = i.industry_id
  
  WHERE  bu.business_id = test
  
  GROUP BY bu.business_id
  ) as indus
  
  FROM reguser r
  </code></pre>
  
  <p>Kindly tell me how can i resolve this issue ?
  Thank you.</p>