how to insert value from one table to other table in sqlite3 database.

Question

hi I am new in iphone i am developing a application with data base i am create a database and have to table we want to insert one table value to other. I am not understand how do this.

if any body know help me with coding.

Answer 1

Nested query: INSERT INTO Table VALUES (SELECT blah...)