> > 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 ???

The ISQL from Firebird supports a copy table function that can be used to
copy tables from one database to another.
Alternatively use QLI

Regards
Paul Beach
Main Tel (UK):+44 (0) 1844 354465
Mobile: (UK): +44 (0) 7764 188603
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information