title: GROUP_CONCAT returning single result
body: <p>I have two tables I am trying to get results from: table in the Users table while table 2 is the education background table.</p>
  
  <p>Let say <strong>user A</strong> has multiple schools he inserted into the education table. if I fetch details from education and join it to users table the record will return by the number of education details inserted by <strong>user A</strong>.</p>
  
  <p>for instance, if I say <code>select * from users u left join education e on u.id=e.fid</code> it returns back the number of times his details appears in education table. </p>
  
  <p>So, I decided to use the query this way:</p>
  
  <pre><code>SELECT j.dob,j.id,j.sname,j.fname, j.mname,j.gender,j.localg,j.stateng,j.phone,j.mails,j.confirm_no,j.edate, GROUP_CONCAT(e.qualification SEPARATOR ', '), GROUP_CONCAT(e.course SEPARATOR ', '), GROUP_CONCAT(e.years SEPARATOR ', ') FROM jobseeker j LEFT JOIN education e ON j.id=e.fid  WHERE j.training_approval_status=1 AND j.confirm_no LIKE 'A%' 
  </code></pre>
  
  <p>but it only returned a single row. What am I doing wrong? Or in what better way can I get the results.</p>