Subject Multi-database query
Author delphigurusam
having referred to Helen's book and knowing little about transactions,
can anyone suggest a starting point for me? 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.
Thx
Sam Hunt