> Sam Hunt wrote,
> I would like to select
> all customers from a table in one database that are also in a
> different table in a different database. if the tables were in the
> same database, I'd create a SQL select statement someting like:
> SELECT CUSTOMERID FROM FIRST_TABLE
> WHERE CUSTOMERID IN
> (SELECT CUSTOMERID FROM SECOND_TABLE)
>
> In my problem question, FIRST_TABLE and SECOND_TABLE are in separate
> databases.

This feature is not supported in firebird, and I must admit that I missed it
too when I switched over from oracle
You will probably end up having to pump the data from the second datavase
into a temp table of the first database to get your answer.
Regards
Gary