DECLARE @NoMember Integer SET @NoMember=1 SELECT Thread.Numero,Thread.Title,Thread.Url,Thread.AddDate FROM (SELECT TOP 10 Reply.NoThread FROM Reply (NOLOCK) WHERE Reply.NoMember=@NoMember ORDER BY 1 DESC) Temp INNER JOIN Thread ON Temp.NoThread=Thread.NumeroBasically, this is the one showing the last 10 replies in the Dashboard. So, ordering by 1, thus by Reply.NoThread, in DESC, would give the most recent ones as NoThread is the Thread.Numero reference, which is the primary key. Or, is it that ORDER BY 1 serves for no use in SQL Server and that I would have to use ORDER BY Reply.NoThread?