title: merging 2 ResultSets with different fields
body: <p>I have a question posted here:<br>
  <a href="https://stackoverflow.com/questions/22239423/java-nested-while-loop-in-result-set/22240017?noredirect=1#comment33775160_22240017">java nested while loop in result set</a></p>
  
  <p>and the answer is correct, but unfortunately my sql server doesn't support insensitive, updatable ResultSets (the error says "<code>the cursor type/concurrency combination is not supported</code>")</p>
  
  <p>What is the best way to merge results from 2 result sets to get the merged result shown below.</p>
  
  <pre><code>ResultSet set1: 
  id | name
  1  | A
  2  | B
  3  | C
  ...
  
  ResultSet set2:
  id | alias
  1  | F
  2  | G
  2  | H
  </code></pre>
  
  <p>I want to print out:</p>
  
  <pre><code>Id: 1, Name: A, Alias: F
  Id: 2, Name: B, Alias: G, H
  </code></pre>
  
  <p>FYI, the id is in ascending orders in both sets. Both ResultSets are results returned from sql queries
  And I don't use UNION because the sql SELECT queries return different fields ('name' and 'alias')</p>