I have another variation of this issue: SELECT col1 - col2 as Total, Total * price FROM tst
.. gives an error " no such column: Total". I can just repeat "col1 - col2" of course, but wondering if there is a way to refer to Total within the SELECT. Thanks, Pete > > > > Message: 6 > > Date: Sun, 23 Oct 2011 21:02:07 +0200 > > From: Kees Nuyt <[email protected]> > > To: [email protected] > > Subject: Re: [sqlite] sqlite-users Digest, Vol 46, Issue 23 > > Message-ID: <[email protected]> > > Content-Type: text/plain; charset=us-ascii > > > > On Sun, 23 Oct 2011 10:26:14 -0700, Pete <[email protected]> > > 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[_] > > > > > > > > ******************************************** > > > >5 > ******************************************** > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
