aspose file tools*
The moose likes Oracle/OAS and the fly likes Adding two records into one record septrated by ',' Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Adding two records into one record septrated by Watch "Adding two records into one record septrated by New topic
Author

Adding two records into one record septrated by ','

pax smith
Ranch Hand

Joined: Dec 13, 2005
Posts: 45
Hi All,

I have a requirement that I have following data in my table

ID LocationID StateID
1 101 1001
2 102 1001
3 103 1001
4 104 1002
5 105 1002


I want to sql query which can return following result

Locations -- StateID
101,102,103 -- 1001
104,105 -- 1002

Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
What do you have so far?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Adding two records into one record septrated by ','