combine the same id in mysql so one colomn
combine the same id in mysql so one colomn and display it in gridview asp.net
example
id provinsi_id kab_id sektor_id
1 2 31 1
2 2 31 2
3 2 31 3
and I want the results like this.
id provinsi_id kab_id sektor_id sektor_id sektor_id
1 2 31 1 2 3