Re: Append two tables into one

On Wed, 14 Mar 2001 19:55:08 GMT, "Doug" <dmccurdy_at_gwrmail.com> wrote:

>What is the best way to append two tables into one table? There are about
>140000 rows to import.
>
>Thank you
>

insert into table1 as select * from table2;

or

create table new_table nologging as (select * from table1, table2 where ...) Received on Wed Mar 14 2001 - 22:10:10 CST