Copying part of a table to another

[santoshym]

Hi

You can use the following statement

create table b as select productname from a;

If the table allready exists you can use the following statement

insert into b(productname) select productname from a;

Regards

[Edited by santoshym on 08-13-2001 at 10:47 AM]