title: How can I join two SELECT statements?
body: <pre><code>select * 
  From
  (
      select * 
      from order 
      order by creationtime desc
  ) 
  where rownum=1 and creationtime='12-feb-2010';
  </code></pre>
  
  <p>and </p>
  
  <pre><code>select * 
  from
  (
      select * 
      from 
      order by rate desc
  ) 
  where rownum&lt;=2 and creationtim='12-dec-2011';
  </code></pre>
  
  <p>I want to join these two <code>SELECT</code> queries, using <code>JOIN</code>. Both <code>SELECT</code> queries query from same table. I do not want use <code>UNION</code>.</p>
  
  <p>How can I achieve this?</p>