[sqlite] adding two tables together

[Jose I. Cabrera]

 imagine...create table t0 (a,b,c);insert into t0 values ('d','e','f');create 
table t1 (a,b,c,de,e,f);insert into t1 values ('a','b','c',(select * from 
t0));Error: table t1 has 6 columns but 4 values were supplied
What I would like is to add t0 to t1 so that t1 now hasa|b|c|d|e|f
What would be the command?  thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users