ORDER BY In Sub Queries

I understand that I have to have a TOP statement to work with an ORDER BY in a subquery but I am unable to get it to work correctly...
I am using VS 2008 and it does throw a "TOP" error, but it does not go ahead and process it correctly like someone said it would in another post...

Is this possible or simply how do I accomplish the following?

Here is an example:





Code Snippet

SELECT ResultSet1.BCol2, ResultSet1.CCol2, ResultSet1.Expr1
FROM
(SELECT TableB.BCol2, TableC.CCol2, count(*) AS Expr1
FROM TableA
INNER JOIN
TableB ON TableA.ACol2 = TableB.BCol1
INNER JOIN
TableC ON TableA.ACol4 = TableC.CCol1 AND TableA.ACol5 = TableC.CCol4
WHERE (TableC.CCol2= 1)

GROUP BY TableB.BCol2, TableC.CCol2) AS ResultSet1
To...





Code Snippet

SELECT ResultSet1.BCol2, ResultSet1.CCol2, ResultSet1.Expr1
FROM
(SELECT TOP (10) TableB.BCol2, TableC.CCol2, count(*) AS Expr1
FROM TableA
INNER JOIN
TableB ON TableA.ACol2 = TableB.BCol1
INNER JOIN
TableC ON TableA.ACol4 = TableC.CCol1 AND TableA.ACol5 = TableC.CCol4
WHERE (TableC.CCol2= 1)


ORDER BY Expr1



GROUP BY TableB.BCol2, TableC.CCol2) AS ResultSet1


What am I obviously missing here?

Thanks a bunch.