On 5 Apr 2012, at 6:05pm, Simon Slavin <[email protected]> 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 even though it doesn't when you use the bracketed form where you define the columns. Okay, ignore that and look at the rest of what I posted. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
