OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
ORDER BY calculated field

From: Neil Tompkins (neildtompkinshotmail.com)
Date: Thu Mar 20 2008 - 05:08:25 CDT

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