SQL

[Mr. Bart Pietercil]

Hi List,

I'm a bit dense today so if anybody could enlighten me for this query:

select objptr_assignment_student_id,count(recid) as 'TotalQ' from  
tbl_results Group By objptr_assignment_student_id

works but it need only those where TotalQ < 25

using HAVING  TotalQ < 25 is accepted by the parser but does not  
influence the cursor (25 is still included)

and WHERE is refused because of using group by.

Inspiration needed

tia

Bart Pietercil