I really need help in writing SQL query for my system. image no 1
In image no 1 you can see I am getting 3 records 2 of same employee. I want the result to be like
my desire output
<h1>My Desired Output</h1>
<table border="1">
<tr>
<th> Name</th>
<th> PrevCompanies</th>
</tr>
<tr>
<td>Ahmad</td><td>Google,Twitter</td>
</tr>
</table>
I am using MYSQL With GROUP_CONCATE I got this result result with group_concate
Any solution how I can get my desire output?