As I say, this is a MS SQL forum, not a MySQL forum, I do not know MySQL.
The example I gave was for MS SQL, you will need to find the MySQL alternative or post the question on a MySQL forum.
Group_Concat is not what you want, that will group the rows together and concatenate.