Re: [GENERAL] adding two tables

Hi again, On Wed, 2004-10-13 at 10:55, fx gamoy wrote: > hello everybody, > i ve got two big tables with the same structure. > > i would like to add the second one to the first one directly without > generating a sql file. (each table is about 1 Million line) > Is it a way with an sql command?

Re: [GENERAL] adding two tables

Hi, On Wed, 2004-10-13 at 10:55, fx gamoy wrote: > hello everybody, > i ve got two big tables with the same structure. > > i would like to add the second one to the first one directly without > generating a sql file. (each table is about 1 Million line) > Is it a way with an sql command? > INSE

[GENERAL] adding two tables

hello everybody, i ve got two big tables with the same structure.   i would like to add the second one to the first one directly without generating a sql file. (each table is about 1 Million line) Is it a way with an sql command? INSERT INTO TAB1... (select * from TAB2) ??? thanks fx