Re: ORDER BY calculated field

[Sebastian Mendel]

Neil Tompkins schrieb:

Hi

I want to order by the totalled fields varProductCount and Products.ProductReviewDESC

just put them together, separated with comma, like it is written in the manual

ORDER BY varProductCount + Products.ProductReviewDESC,
COUNT(ProductsPurchases.ProductID)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]