• 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.