INSERT INTO myTable (Rd, en, ue) SELECT 'aa', 'bb', ue FROM othertable; Rick
On Jul 22, 2012, at 7:41 PM, YAN HONG YE wrote:
> INSERT INTO myTable (Rd, en, ue) VALUES ("aa","bb",select ue from othertable);
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
