title: Select top N with joins
body: <p>I am looking to join 2 tables with top n results of other table as explained below.</p>
  
  <p>OrderHeader</p>
  
  <pre><code>OH_Id        OrderDate
  ----------------------
  1            2014-06-01
  2            2014-06-02
  3            2014-06-03
  4            2014-06-04
  5            2014-06-05
  </code></pre>
  
  <p>OrderProducts</p>
  
  <pre><code>OP_Id        OH_Id    Quantity
  ------------------------------
  1              1       1
  2              1       2
  3              2       1
  4              3       3
  5              4       4
  6              4       1
  7              4       2
  8              5       2
  9              5       1
  </code></pre>
  
  <p>I am expecting result something like this for top 3 orders (4 rows).</p>
  
  <pre><code>OH_Id        OrderDate       Op_Id      Quantity
  ------------------------------------------------
  1            2014-06-01      1           1
  1            2014-06-01      2           2
  2            2014-06-02      3           1
  3            2014-06-03      4           3
  </code></pre>
  
  <p>Note: I am looking specifically to join 2 tables rather writing as SP or looped queries.</p>