Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

merging 2 resultset and printing

 
ranga shreya
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am getting 2 resultset 1 has more records key is taskno.
another one has less records key is takno.
How can we merge and these two and print it in sorting order.
task nos arein string (condition is we have compare strings)
Thanks
Ranga
 
Jeff Albertson
Ranch Hand
Posts: 1780
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you write the query using an SQL UNION? Then you can have your DBMS do the sorting.

How to print: http://java.sun.com/docs/books/tutorial/2d/printing/index.html
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic