Hello dB gurus,
Can anyone let me know how to query 2 diffrent dBs sitting on 2 diff servers?
I had ORDERS dB(DB2) on one server and Dept dB(DB2) on a different server.I am using MS-Query to query these databases.My question is can I write a single SQL statement to select the data from diff tables from these two diff dBs on diff servers.If so any kind of DSN set up?
Does this query work?
SELECT ORDERS_dB.ORDERS_TABLE.ORDERS_FIELD,DEPT_dB.DEPT_T ABLE.DEPT_FIELD
WHERE
ORDERS_dB.ORDERS_TABLE.ORDERS_SomeKEY=DEPT_dB.DEPT _TABLE.DEPT_SomeKey
Thanks in advance,
Shiva

Federated Databases

Cheers
Sathyaram