>select Temp.NoThread, MessagesPerThread > from (SELECT Top 10 NoThread FROM Thread ORDER BY Numero DESC) Temp inner join >(select NoThread, count(*) as MessagesPerThread from Thread group by NoThread) CountMessages >on Temp.NoThread = CountMessages.NoThread >This works. Thanks