Re: [sqlite] how to write this sql command?

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] how to write this sql command?

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