Re: Heterogeneous Join
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