Thanks Sebastian, but I now get the error message [MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function
> Date: Thu, 20 Mar 2008 12:59:22 +0100> From: [EMAIL PROTECTED]> To: > mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Sebastian > Mendel schrieb:> > 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)> > > > sorry:> > ORDER BY > COUNT(ProductsPurchases.ProductID) + Products.ProductReviewDESC> > -- > > Sebastian> > -- > MySQL General Mailing List> For list archives: > http://lists.mysql.com/mysql> To unsubscribe: http://lists.mysql.com/[EMAIL > PROTECTED]> _________________________________________________________________ Share what Santa brought you https://www.mycooluncool.com
