Sqlite - Copy one table into another one

[fatman]

Hi Folks,

I have 2 tables: a large (inifinite one) one a small one (with 10 records).
I need to copy the 10 records into the large table.
Tried to loop through the small table but failed.

Any hints, snippets or how to´s are welcome!

Fatman

 

[Erel]

Can you post the code you tried?

 

[fatman]

Thx Erel,

found it: INSERT INTO table1 SELECT * FROM table2

Thank you anyway!