Re: query different connections with one recordset

Hi Christian,

It should still work in ADO.

In ADO with SQL Server 7.0 for example you connect with a default database name and can then use a SQL Statement like:

select * from table1 as t1 inner join database2..table1 t2 on t1.id = t2.id

databasename..tablename (two dots) indicates to look in the other database (on the same server).

--
-Dick Christoph
dchristo_at_minn.net
http://www1.minn.net/~dchristo


"Christian Seifert" <cseifert2_at_escs.de> wrote in message
news:3a7aaa67.0_at_195.63.75.2...


> 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

>

>

>

>