title: SQL Server - select Top 2 in Inner Join
body: <p>I am new to sql server, i am having Join with two tables. The problem is One table say [TABLE1] is having only 1 row but the other table say [TABLE2] can have many rows.</p>
  
  <p>i wanted to create a Query which can retrieve 1 row from TABLE1 and 2 top rows from TABLE2.</p>
  
  <p>note: Both the tables have 1 common column so i have created Join.</p>
  
  <p>I tried using TOP 2 - but this didn't worked</p>
  
  <pre><code>    select T1.Col1 , Top 2 T2.Col1, ....
      from TABLE1 T1
      inner join TABLE2 T2
      ON T1.commonRow =  T2.commonRow
  </code></pre>
  
  <p>Below is the structure of table1 &amp; table2</p>
  
  <pre><code>    TABLE 1      TABLE2 
      -----------------------------
       DATA        COMMENTS 1
                   COMMENTS 2
                   COMMENTS 3
                   COMMENTS 4
  </code></pre>
  
  <p>can some one help!!</p>