>>>>Your order by here is strange. I would probably re-write the whole query as
>>>>
>>>>select * from (select T.Numero, T.Title, T.Url, T.AddDate, row_number()
>>>>over (partition by R.NoThread order by R.NoThread) as Row from Thread T LEFT JOIN Reply R on T.NoThread = R.NoThread) X
>>>>where Row <=10
>>>
>>>I do not understand why it would be strange. The 10 records I need to select from Reply are subject to a specific order. To me, this is the clean way to do it.
>>
>>What does ORDER BY 1 DESC mean?
>
>VFP order by the first field in descending order. Even then that is not really used (or better not used I think). I see it sometimes though. Perhaps he had VFP on his mind??? :o)
Actually, right - my mistake. I got so used to spelling the field name, that I forgot of using ordinal position in ORDER BY.
Just in case - very nice blog on this topic
http://bradsruminations.blogspot.com/2010/01/trolls-puzzle-sql-fable.html
If it's not broken, fix it until it is.
My Blog