SELECT TOP 100 dt1.Numero,WishList.Title, dt1.Rating, dt1.Rates ; FROM ( SELECT WishList.Numero,SUM(Rate)/COUNT(*) AS Rating,COUNT(*) AS Rates FROM Rating; INNER JOIN WishList ON Rating.NoEntry=WishList.Numero; WHERE NoContent=2 GROUP BY 1 ; ) dt1 ; INNER JOIN WishList ON dt1.Numero=WishList.Numero; ORDER BY 3 DESCENDING,4 DESCENDING INTO CURSOR Temp>I would like to have the following SQLs adjusted so I can have everything into on SQL:
>SELECT WishList.Numero,SUM(Rate)/COUNT(*) AS Rating,COUNT(*) AS Rates FROM Rating; > INNER JOIN WishList ON Rating.NoEntry=WishList.Numero; > WHERE NoContent=2 GROUP BY 1 INTO CURSOR Temp >SELECT TOP 100 Temp.Numero,WishList.Title,Temp.Rating,Temp.Rates FROM Temp; > INNER JOIN WishList ON Temp.Numero=WishList.Numero; > ORDER BY 3 DESCENDING,4 DESCENDING INTO CURSOR Temp >>