Gary Benade wrote:

>>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
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

According to Helen's book, FB152 handles multi-database joins using
2-phase commits and explicit transactions.
(What did I just say?!)
Since I barely understand THIS subject well enough to regurgitate what
I've read, I must stop here.
However, I have successfully written "normal" single-database,
mutli-table edits under transaction control in Delphi, so I do
understand the subject somewhat.
Any and all additional comments welcome.
Sam Hunt