If it's the same structure, you just need to do exactly as you propose..
insert into tableA (select * from tableB)

> -----Original Message-----
> From: column@... [mailto:column@...]
> Sent: Tuesday, 12 November 2002 19:45
> To: ib-support@yahoogroups.com
> Subject: [ib-support] select from one_database.table into
> another_database.table
>
>
> Hi,
>
>
>
> I need to do this action:
>
> Select from one_database.table into another_database.table
>
>
>
> Is it possible to do this with stored procedure?
>
>
>
> If no then is it possible to do wit IBX components? If yes then
> what is the
> best way to do that?
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>