Hi, I have a table which has four columns as say (RoomId, RoomName, SwitchID, SwitchName.) Now I want to merge last three columns depending upon first column(i.e RoomID)
means supppose in a table I have following data 1:BedRoom:1:AC 1:BedRoom:2:CFL 1:BedRoom:3:Tube 2:Guest Room:4:cooler 2:Guest Room:5:Bulb 3:Kitchen:6:CFL 3::Kitchen:7:Fan 3:::Kitchen:8:TV 1::BedRoom:9:cooler 4:Guest Room:10:cooler 5:Study Room:11:AC 5:Study Room:12:Tube 2::Guest Room:13:Bulb Now what I want is depending upon first column (i.e RoomID) other column must have to be merge and therefore data will be like this 1:BedRoom:1:AC:2:CFL:3:Tube:9:cooler How it is do? Thanks -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en