Show Employees and its companies in one row

Viewed 23

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?

0 Answers
Related