[RESOLVED] count and group

[BEFOR]

This query is to show only results having greater than 4 of the same Ocounty.

SELECT COUNT(Ocounty) as Ocounty_count, OID, Xterm
FROM Omessages, Xtable
WHERE Xtable.Xcomment=Omessages.Ocomment AND Omessages.Otype = 'Programmers'
GROUP BY Ocounty_count HAVING Ocounty_count >4
ORDER BY Ocounty

But it errors. How can it be written to work?

[Masna]

What's the error?

[BEFOR]

cannot Group on Ocounty_count

(is this somthing about it being aggregate?)

Think this is happening because there is a count on that same col.

[BEFOR]

This seems to work:

SELECT OID, Xterm, COUNT(Ocounty)
FROM Omessages
INNER JOIN Xtable on Xtable.Xcomment=Omessages.Ocomment AND Omessages.Otype = 'Programmers'
GROUP BY Ocounty
HAVING COUNT(Ocounty) >4
ORDER BY Ocounty