TSQL - TOP X in FROM Subquery?

Posted by EWizard on Stack Overflow See other posts from Stack Overflow or by EWizard
Published on 2010-05-07T20:14:16Z Indexed on 2010/05/07 20:18 UTC
Read the original article Hit count: 619

Filed under:
|
|

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:

SELECT * FROM
TABLE_A
LEFT JOIN (TOP 8 TABLE_B )
                ON TABLE_B.id = TABLE_A.id

© Stack Overflow or respective owner

Related posts about tsql

Related posts about subquery