hi friends,

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

this query is not executing because it is not function but i have to check the condition of a count function and join in where clause

can anybody help me

padmapriya:

hi friends,

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

this query is not executing because it is not function but i have to check the condition of a count function and join in where clause

can anybody help me

 

padmapriya:

hi friends,

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

this query is not executing because it is not function but i have to check the condition of a count function and join in where clause

can anybody help me

 

Have you tried this?

Hope it helps.  Regards, Grady Christie