A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (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 "[EMAIL PROTECTED]" "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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster