Query over multiple databases

Andreas Sisask

Delphi Developer

Mon, 09 Feb 2004 16:22:58 GMT

Query over multiple databases

Hello,

Is it possible to make a SELECT over multiple database, smth like this:

SELECT K1.NAME, K2.PHONE FROM DATABASE1.TABLEK, DATABASE2.TABLEK WHERE K1.ID
= K2.ID

Andreas

Jaimy Azl

Delphi Developer

Mon, 09 Feb 2004 18:31:56 GMT

Re:Query over multiple databases

Quote

> Is it possible to make a SELECT over multiple database, smth like this:

> SELECT K1.NAME, K2.PHONE FROM DATABASE1.TABLEK, DATABASE2.TABLEK WHERE
K1.ID
> = K2.ID

No, it could not be done. retrieving data from multiple database is not
supported.

HTH,

-Jaimy
--
Jaimy Azle | Principle Developer
Center of Computer Development System
Faculty of Economics - Gadjah Mada University
http://www.ppkfeugm.com

Andreas Sisas

Delphi Developer

Mon, 09 Feb 2004 19:30:32 GMT

Re:Query over multiple databases

Suppose I make a connection with JDBC to one database. Is there any way to
get data from other database without making separate connection to it?

Andreas

Quote

"Jaimy Azle" <ja...@nospam.sat.net.id> wrote in message

news:3b84d96d$1_2@dnews...

Quote

> > Is it possible to make a SELECT over multiple database, smth like this:

> > SELECT K1.NAME, K2.PHONE FROM DATABASE1.TABLEK, DATABASE2.TABLEK WHERE
> K1.ID
> > = K2.ID

> No, it could not be done. retrieving data from multiple database is not
> supported.

> HTH,

> -Jaimy
> --
> Jaimy Azle | Principle Developer
> Center of Computer Development System
> Faculty of Economics - Gadjah Mada University
> http://www.ppkfeugm.com