Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes merging result sets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "merging result sets" Watch "merging result sets" New topic

merging result sets

Prakash Dwivedi
Ranch Hand

Joined: Sep 28, 2002
Posts: 452
Hello Friends i have a problem:
I have to retrieve data from two tables each table contains two fields(for simplicity otherwise there are more) ie date and name. I have to merge the data from two result set and display the data sorted in order of date.
Like this

As you can see it is possible that a table may not contain any entry for particular tdate in that case that field should be left blank.
Any suggestions.
[ December 02, 2002: Message edited by: Prakash Dwivedi ]

Prakash Dwivedi (SCJP2, SCWCD, SCBCD)
"Failure is not when you fall down, Its only when you don't get up again"
Braj Prasad

Joined: Apr 08, 2002
Posts: 16
Write a single query joining the two tables, and do an outer join for the fields that can be null.
Once, you get the result set, check for it being NULL , by using the method ResultSet.wasNull(), after retreiving the value:
String lStrTemp=ResultSet.getString(ColumnName);
I agree. Here's the link:
subject: merging result sets
It's not a secret anymore!