database query

G

gandy

is it possible to query two tables in different .mdb files in a similar fashion as when i query two tables in the same .mdb file

select * from table1 where field1 = field
UNIO
Select * from table2 where field1 = field

This is basically how i join tables in the same database. Is there something similar that will join two tables in different databases?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top