Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Heterogeneous Join
"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 - 06:10:05 CDT