> I have 2 databases (db1 and db2).
>
> I need to use a sql statement to copy data from tableX from db1 to tableY
> from db2
>
> How do I do that ???
> Do I have to include the database name (eg db1 or db2) in the query ???

Not in SQL.

In IBObjects you use a datapump, and connect the source and
destination to the different databases, but you can't do it
directly.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services