F fatman Active Member Licensed User Longtime User Jul 30, 2015 #1 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
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 B4X founder Staff member Licensed User Longtime User Jul 30, 2015 #2 Can you post the code you tried?
F fatman Active Member Licensed User Longtime User Jul 31, 2015 #3 Thx Erel, found it: INSERT INTO table1 SELECT * FROM table2 Thank you anyway!