From: Jining Han Newsgroups: basicworld.public.basicpro,basicworld.public.events,basicworld.public.vb.allgemein,basicworld.public.vb.datenbank Subject: Re: query different connections with one recordset Date: Sat, 03 Feb 2001 01:10:31 GMT Organization: Deja.com Lines: 35 Message-ID: <95flq3$2fq$1@nnrp1.deja.com> References: <3a7aaa67.0@195.63.75.2> NNTP-Posting-Host: 4.4.234.222 X-Article-Creation-Date: Sat Feb 03 01:10:31 2001 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95) X-Http-Proxy: 1.1 x72.deja.com:80 (Squid/1.1.22) for client 4.4.234.222 X-MyDeja-Info: XMYDJUIDjining_han In article <3a7aaa67.0@195.63.75.2>, "Christian Seifert" 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/