Subject | Multi-database query |
---|---|
Author | delphigurusam |
Post date | 2005-06-20T19:51:36Z |
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
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