Select query on two databases

[parminder]

Hi to all

Who can we run VB.NETs SELECT query on two MS-Access database. For example :

There are two databases: Database1 and Database2
There are two tables Table1 and Table2 from Database1 and Database2 respectively.
Table1s field "Field1" and Table2s field "Field2" are for to store common object (datatype)

Now how can I run the query like this:

Select * from Table1,Table2 where Table1.Field1=Table2.Field2


How it is possible in VB.net (ADO.NET)

Thanks in Advance

 

[mrdutchie]

My guess would be LINKING 1 database into the other one.