Re: Heterogeneous Join

From: Rich Woods <rawoods_at_cfl.rr.com>
Date: Thu, 26 Apr 2001 01:56:26 GMT
Message-ID: <3AE77FF5.807A190A@cfl.rr.com>

Via database links.

Select ......
From table1_at_db1, table2_at_db2, .....
Where table1.column1 = table2.column2 ....

"Mark A. Richman" wrote:

> How do I set up a heterogeneous join? That is, query multiple databases
> simultaneously using a join clause? Is this possible via JDBC?
>
> Thanks.
>
> --
> Mark A. Richman
> Empire Software, Inc.
> Expert Software Development & Consulting
>
> + Internet/Intranet/Extranet
> + E-Commerce & B2B
> + Java, C/C++, Visual Basic
> + XML, SOAP, and Web Services
> + Linux & Open-Source Solutions
> + Database Applications
> + ...and MUCH more!
>
> http://www.empsoft.com
Received on Wed Apr 25 2001 - 20:56:26 CDT