On Sun, 08 Dec 2002 22:38:40 +0100Alexander Pucher <pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at> wrote:
> I have two tables with identical table stucture. How can i add all rows > from table2 into table1, i.e concatenate the two tables.
I think following will accomplish this for you:
insert into table1 select * from table2;
Or, if you want the concatenation of table1 and table2 in a new table:
select * into table3 from (select * from table1 union select * from table2) as tmp