Re: [sqlite] SELECTing WHERE calculation > 0

"Edward Lau" wrote... Hi Jose: In SQL, aggregate function cannot be used in the WHERE clause. Use the HAVING clause instead. Try this: SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund),

Re: [sqlite] SELECTing WHERE calculation > 0

"Richard Hipp" wrote... Do you want a HAVING clause? Thanks. Didn't know about this one. Now it works: SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund), sum(ProjFund)-sum(CASE Xtra4 WHEN 'y'

Re: [sqlite] SELECTing WHERE calculation > 0

'y' then invoice else 0 end) > 0 -Original Message- From: jose isaias cabrera <cabr...@wrc.xerox.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thu, May 29, 2014 2:18 pm Subject: [sqlite] SELECTing WHERE calculation > 0 Greetings!

Re: [sqlite] SELECTing WHERE calculation > 0

Do you want a HAVING clause? On Thu, May 29, 2014 at 5:14 PM, jose isaias cabrera wrote: > > Greetings! > > I have this select, > > SELECT cust, > ProjID, > proj, > A_No, > bdate, > CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, >

[sqlite] SELECTing WHERE calculation > 0

Greetings! I have this select, SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund), sum(ProjFund)-sum(CASE Xtra4 WHEN 'y' THEN invoice ELSE 0 END), sum(CASE Xtra4 WHEN 'y' THEN invoice ELSE 0