Hi I want to order by the totalled fields varProductCount and Products.ProductReviewDESC Neil
> Date: Thu, 20 Mar 2008 11:36:30 +0100> From: [EMAIL PROTECTED]> To: > mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Neil > Tompkins schrieb:> > Hi,> > > > How do I achieve a SQL statement to order my > results based on two calculated fields for example :> > what two calculated > fields?> > > > 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> > > ORDER BY COUNT(ProductsPurchases.ProductID)> > -- > Sebastian Mendel> > -- > > MySQL General Mailing List> For list archives: http://lists.mysql.com/mysql> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]> _________________________________________________________________ Telly addicts unite! http://www.searchgamesbox.com/tvtown.shtml