On Tue, 13 Jul 2010, Calimeron wrote:
>
> Can somebody point me in the right direction?
>
> I have joined the two tables by doing: select * from ChineseTable,
> EnglishTable on IDX_c = IDX_cedict
>
> Now I would like to save this as a new table, so I can manipulate this table
> in sqlite and other programs.
You can create a table from a SELECT statement, i.e., CREATE TABLE mytable
AS SELECT ...
See http://www.sqlite.org/lang_createtable.html
Chris
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
