Pete Molly's Revenge <http://www.mollysrevenge.com>
Thanks Kee, that explains it. > > Message: 6 > Date: Sun, 23 Oct 2011 21:02:07 +0200 > From: Kees Nuyt <k.n...@zonnet.nl> > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite-users Digest, Vol 46, Issue 23 > Message-ID: <kvo8a7lnardp6tmk7jtm0qpnc9eesqu...@dim53.demon.nl> > Content-Type: text/plain; charset=us-ascii > > On Sun, 23 Oct 2011 10:26:14 -0700, Pete <p...@mollysrevenge.com> > wrote: > > >Apologies, I omitted what is the real cause of the problem. This > simplified > >SELECT illustrates the error: > > > >SELECT sum( colc * cold ) as total from tst where total > 1000 > > > >The error message is "misuse of aggregate: sum()". No error if I remove > the > >where clause. > > A condition on an aggregate is expressed with a HAVING clause, not > a WHERE clause. > > That is because WHERE and HAVING work on different stages of the > SELECT statement: WHERE decides which rows to include in the > aggregate, HAVING decides which results to present after > aggregation. > -- > ( Kees Nuyt > ) > c[_] > > > > ******************************************** > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users