I have a database that only include one talbe.the talbe has two fields. code and unit.
code unit
a tees
b kdkd
c ddk
a dd
a gakka
c akak
b kakka
I want to get the reslut(listdown) by a query
code field1 field2 field3 ... and so on
a tees dd gakka
b kdkd kakka
c ddk akak



Somebody help me,here thanks.