Re: Aggregates not allowed in WHERE clause?

A long time ago, in a galaxy far, far away, fransgunawan@gmail.com (Frans) wrote:
> This yields the message: 'Aggregates not allowed in WHERE clause'.
>
> Can somebody help me here....

What it says is right; SQL does not permit using aggregates in the
WHERE clause.

You need to look at the HAVING clause which is, more or less, the
equivalent to WHERE specifically for use with aggregates...
--
(format nil "~S@~S" "cbbrowne" "gmail.com")
http://www.ntlug.org/~cbbrowne/nonrdbms.html
"If  use of  the GPL filters  out people   who are  only interested in
inventing the  worst possible motives  for my  actions then,  yes, I'm
happy to learn that it serves a useful purpose  I'd never thought of."
-- Dave Pearson