On 4/5/2012 1:09 PM, Simon Slavin wrote:
On 5 Apr 2012, at 6:05pm, Simon Slavin<slav...@bigfraud.org> wrote:
I don't understand what you think is wrong with
insert into t3 SELECT Col1 FROM t2;
Oh, now I do. Okay, SQLite insists on the number of columns matching when you
use a sub-SELECT
So you could just do
insert into t3(Col1) SELECT Col1 FROM t2;
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
