try

insert into tableb select id,code from tablea

or

insert into tableb select id,code,'' from tablea

to avoid Nulls in misc

----- Original Message -----
From: "rockwithme77" <rockwithme77@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, November 27, 2003 6:46 PM
Subject: [firebird-support] Transfer data between two tables


| 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.
|
|
|
|
|
|
| To unsubscribe from this group, send an email to:
| firebird-support-unsubscribe@yahoogroups.com
|
|
|
| Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|