Thanks for the help. However I found another solution which is to use the following SELECT COUNT(ProductsPurchases.ProductID)+Products.ProductReview as varProductCount, Products.Name, Products.ProductReviewFROM ProductsPurchasesINNER JOIN Products ON Products.ProductID = ProductsPurchases.ProductIDGROUP BY Products.ProductID ORDER BY varProductCount DESC
> Date: Thu, 20 Mar 2008 13:08:51 +0100> From: [EMAIL PROTECTED]> CC: > mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Neil > Tompkins schrieb:> > Thanks Sebastian, but I now get the error message> > > > > [MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function> > i > am not familiar with ODBC or MySQL 3.x> > but possible just GROUP BY is > missing> check the manual for your mysql version for the exact syntax> > if > this is not working at all you have to use HAVING> > -- > 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