Re: Insert Statement

insert into B select * from A;

Originally posted by Tony Rees

> Dear All,

>

> Can anyone provide the insert statement for me to allow me to copy
> data from

> table A to table B.

>

> ie select into A as select * from B (or something similar)

>

> I know that I can do the following

>

> create table B as select * from A

>

> but this is not what I want to do. Both tables have exactly the same

> structure. Table B is truncated as part of the process thus
> hanging on to

> it's indexs and other objects

>

> Appreciate help

>

> regards

>

> Tony Rees

tony_rees_at_stratexnet.com

--
Posted via http://dbforums.com