I believe you have to add your AVG() to your GROUP BY clause. > I have a sql query as follows: > > ************************** > SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > > FROM > ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON > ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID > > WHERE > AVG(DB_GRADE) > 2 > > GROUP BY > ES.DB_ESTABLISHMENT_ID > ; > ************************** > and I get the following error: > > ERROR 1111: Invalid use of group function > > Can anyone tell me how to use a function in the where clause? > > Thanks in advance, > > Julien. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
