He didn't misunderstand you. The only way to get the result you indicated in SQLite is to use 2 SQL statements. If you're worried that another process might change the data between the 2 statements, put them in a transaction:
begin;select data...;select sum(X)...;end; If you're worried about efficiency or speed, since the table will be scanned twice, it might (or might not) be better to do the sum in your host language. Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
