This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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 ','
 
Similar Threads
SQL How to not select the record
Bulk Data Processing
Selected value getting lost on form Submit
calling a parameter from html to javascript
how to pass array value in sql