I have a query which returns 10 rows and 10 columns. Person_Id is primary key. The result set may be like Person_id Name, City, Telephone 1 Siva Pondy 1123 For each person_id there are 15 organizations.
1 O1 1 O2 1 O3
I want all the organizations combined with previous set into single row. Like
Name, City, Telephone, Org1, Org2, Org3, Org4. Siva Pondy 1123 O1 O2 O3 O4.