Re: Heterogeneous Join

From: Robert Klemme <robert.klemme_at_myview.de>
Date: Thu, 26 Apr 2001 13:10:05 +0200
Message-ID: <3AE8020D.36A468EB_at_myview.de>


"Nils O. Sel sdal" schrieb:
>
 

> "Robert Klemme" <robert.klemme_at_myview.de> wrote in message
> news:3AE7CE36.BEED1659_at_myview.de...
>
 

> Rich Woods schrieb:
> >
> > Via database links.
> >
> > Select ......
> > From table1_at_db1, table2_at_db2, .....
> > Where table1.column1 = table2.column2 ....
>
 

> are you sure that this is supported by every JDBC driver? if not, can
> you state which driver does this?
>
 

> A jdbc driver just sends the sql query, it doesnt analyze it...
> If your DBMS supports it, the jdbc driver will also...unless its a real
 ly
> really
> crappy driver, that isnt jdbc conformant.(then it would fail other quer
 ies
> also, not just joins...)

well, yes, you are right. what i really wanted to know: which DBMS's do support this?

and an additional remark: this most likely does not work accross product boundaries, i.e., you won't be able to have a mixed query to a Sybase and an Oracle DB.

        robert

-- 

Robert Klemme
Software Engineer
-------------------------------------------------------------
myview technologies GmbH & Co. KG
Riemekestra e 160 ~ D-33106 Paderborn ~ Germany
E-Mail: mailto:robert.klemme_at_myview.de
Telefon: +49/5251/69090-321 ~ Fax: +49/5251/69090-399
-------------------------------------------------------------
Received on Thu Apr 26 2001 - 13:10:05 CEST

Original text of this message