Oh, sorry, the example was just an example. The calculations I need to make on on ColC cannot be done within SQLite.
----- Original Message ----- From: "Szomraky, Stefan" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, July 15, 2008 8:19 AM Subject: Re: [sqlite] General help, a bit OT > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of cstrader >> Sent: Tuesday, July 15, 2008 2:03 PM >> To: General Discussion of SQLite Database >> Subject: [sqlite] General help, a bit OT >> >> A bit off topic, but perhaps someone could direct me. >> >> I'm in vb.net >> >> I have to read thousands of tables and operate on each one in >> sequence. I need to do this fast. >> >> I want to read the data from 6 stored columns and many rows >> from each table. >> >> Once the table is read, I need to create derived columns >> (e.g. (new) Column C = column A + ColumnB). > > > Why does SELECT ColA, ColB, ColA+ColB AS ColC FROM tab1; not work? > > Greetings, > Stefan Szomraky. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users