I think you created a column in table1 named "int" of type "id".
Try: CREATE TABLE table2 (id int); Then sum() should work. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, New York 12065 518-371-3983 x113 (work) 860-508-5015 (cell) -----Original Message----- From: LoGi [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 03, 2007 2:13 PM To: [email protected] Subject: [sqlite] cant sum rows I create table with this sql: CREATE TABLE table1 (int id); and fill with some randomize values I try this sql: SELECT SUM(id) FROM table1 to sum the table rows but its return error no such column: id i use the sqlite from a c++ code with this function sqlite3_get_table(); thanks. -- View this message in context: http://www.nabble.com/cant-sum-rows-tf2915362.html#a8146664 Sent from the SQLite mailing list archive at Nabble.com. ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
