At 02:17 PM 15/12/2003 +0000, you wrote:

>Thanks for ur prompt response.
>Can u tell me where can I get an example for this sort of query?

They are just queries. A query on one database and a query on another.

>I wanted to do it from within an input file given to isql. Or even if I
>could do it from within a stored procedure.

Neither. ISQL is a single-connection, single-transaction tool. Input
files run in isql's transaction. Stored procedures can't connect to databases.

You would need to write an application, using the API or some application
interface that implements the API fully, like Java + Jaybird or Delphi +
IBObjects.

If your objective is to pump data between two databases, use another
tool. The IB_Datapump in IB_SQL (free from www.ibobjects.com) is great for
that. You run a SELECT query on the source table(s) and an insert or
update query on the target table, and you can massage data on the way
through using expressions.

/helen