Hi,

if I have

tableA (id integer,code varchar(5))

and a tableB which I need to create as

tableB (id integer,code varchar(5),misc varchar(10))

I want to have all data in tableA in tableB.

Is there a way to do this with a single script.

Regards,
sguha.