Greetings.  Very newbie question...

I have these records...
id,invoice, transfer, price
1,0,0,0
...
10,500.00,200.00,0.00
...
200,300,300, 200
...
334,3000, 200,3000
...

what I would like to do is to add invoice, transfer and price.  I have this,

SELECT sum(invoice),sum(transfer),sum(price) where id = 10,200,334;

Of course, it does not work.  Any help would be greatly appreciated.  Thanks.

josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to