>>Ok, here are ways of getting what you want:
>>
>>

>>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

You're welcome.