> What will be the generic SQL syntax to 'pump' (insert) data from colums
> in table x, database 1, to similar colums (different name) in table y
> from database 2 ? The two databases may be on different Firebird
> servers. Thanks.
>
> RP

Use CleverComponents datapump - it's all done for you.
If you need this all the time, then it has to be done by a client, not a
server. Try IBO components which has a datapump component.
Alan