> For example say DB1 and DB2. DB2 is a copy of DB1. Only difference is
> that DB1 is having records and DB2 is empty. Now I am trying to write
> a query from which I can insert a particular record from DB1 to DB2. I
> have written following query
>
> "Insert Into [DB2].Table1 select * from Table1 where ID = 10;"
>
> Is it possible to cross - database access through query?
> which is supported by oracle and MS-Sqlserver. Can firebird support or
> not?

Firebird itself does not.

qli, a command line tool that comes with Firebird, does, more or less.
It has a slightly different syntax for things.


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com