Re: query different connections with one recordset

In article <3a7aaa67.0_at_195.63.75.2>,
  "Christian Seifert" <cseifert2_at_escs.de> wrote:
> with DAO and access it is possible to do innerjoin select sql queries
 with
> tables that are not in the same db.
>
> e.g.
>
> SELECT tbl1.*, tbl2.* FROM " & db1.name & ".tbl1 INNER JOIN " &
 db2.name &
> ".tbl2 ON tbl1.c1 = tbl2.c1;
>
> this works perfectly. but what about when you do this in ADO? There
 you
> don't have a db and therefore no db.name.
> help would be grately appreciated
>
> Christian
>
>

First of all, you don't join databases, you join tables; Secondly, if you are not asking about ADO-Oracle interfacing, then this is the wrong group.
Thirdly, if you need to join two Oracle tables from different databases, you can use dblink, and
Lastly, not every database supports ANSI join yet.

--
Jining Han
Sallie Mae


Sent via Deja.com
http://www.deja.com/