combine the same id in mysql so one colomn

Mar 21 2015 3:41 PM
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                       

Answers (3)