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? > INSERT INTO TAB1... (select * from TAB2) ???
without the ... your statement is complete. Have fun Tino ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]