Querying two databases

[Neil_Pattison]

Hi all,

Is it possible to create a query that looks over two different databases for information. i.e I have two departments at work that have seperate databases and I need to be able to search for data in both of them on the same query.

Any help would be greatly appreciated.

 

[Snak]

Suggest you use File > Get External Data > and LINK your two databases together. You should then be able to include tables from both databases in a single query.

 

[boblarson]

The only way you can do that is if you link to one of the databases via the other and then you will have to either create a UNION query if you want all data from both, or a regular query if you can tie them together via a common key and you only want either all data from one and only data that matches in the other (Left Outer Join), or only data that has a matche in the other (Inner Join).