Hi,
How do I achieve a SQL statement to order my results based on two calculated
fields for example :
SELECT COUNT(ProductsPurchases.ProductID) as varProductCount, Products.Name,
Products.ProductReview
FROM ProductsPurchasesINNER JOIN Products ON Products.ProductID =
ProductsPurchases.ProductIDGROUP BY Products.ProductID ORDER BY
varProductCount+Products.ProductReviewDESC
Thanks
Neil
_________________________________________________________________
Telly addicts unite!
http://www.searchgamesbox.com/tvtown.shtml