Hi,
I am having some problem in merging the two same type of result set.
For example,
String sql1 = select * from Sales where Invoice>5 and invoice<10 has ResultSet rs1, And
String sql2 = select * from Sales where invoice >10 has ResultSet rs2.
Now what i simply want is to add or merge this two resultSets rs1 and rs2.
Please this is only the sample code. Making of this two individual result set is really complex and i cant write such a long code that contains joinRowSet and all that stuff to make this ResulSets.
So please help to me add or merge this two resultSet.
Thanks,