Insert Statement

From: Tony Rees <tony_rees_at_stratexnet.com>
Date: Thu, 28 Aug 2003 13:52:19 +0100
Message-ID: <biktm6$ut$1$8300dec7@news.demon.co.uk>

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 Received on Thu Aug 28 2003 - 07:52:19 CDT