Hi to all,

Who can we run VB.NET's 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.
Table1's field "Field1" and Table2's 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