title: TSQL - TOP X in FROM Subquery?
body: <p>Can someone please enlighten me to a way to filter a subquery that is located in a FROM clause?
  I would like it to look something like this:</p>
  
  <pre><code>SELECT *
  FROM TABLE_A
  LEFT JOIN (TOP 8 TABLE_B) ON TABLE_B.id = TABLE_A.id
  </code></pre>