From: "Christian Seifert" <cseifert2@escs.de>
Newsgroups: basicworld.public.basicpro,basicworld.public.events,basicworld.public.vb.allgemein,basicworld.public.vb.datenbank,comp.databases,comp.databases.ms-access,comp.databases.ms-sqlserver,comp.databases.oracle.misc,comp.lang.basic.visual.database
Subject: query different connections with one recordset
Date: Fri, 2 Feb 2001 13:40:41 +0100
Organization: Tiscali / Nacamar
Lines: 17
Message-ID: <3a7aaa67.0@195.63.75.2>
NNTP-Posting-Host: 195.63.75.2
X-Trace: wrath.news.nacamar.de 981117564 74023 195.63.75.2 (2 Feb 2001 12:39:24 GMT)
X-Complaints-To: abuse@nacamar.de
NNTP-Posting-Date: 2 Feb 2001 12:39:24 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211


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