doubt in query

[solvemyqueries]

hi friends.

i had to execute this query,but it post a error saying"its not a group function"

The query is "select name,count(trainingdates) from tablenames group by having count(trainingdates)<=5 and tablename.trainerid=tablename.trainerid

i need to compare the count function and join query using where clause,can any body help me please

[Pilgrim333]

Hi,

Your query should be:

select name,count(trainingdates) 
from   tablenames 
group by name having count(trainingdates)<=5 and   
                     tablename.trainerid=tablename.trainerid
 

Your output contains the column name, and a count. Name should be in your group by clause.

Pilgrim.

[debasisdas]

as suggested in the previous post you need a field to group by ,which is missing in your query.