VB code to query two tables in different databases

[UB]

Is it possible to write a VB query that joins one table
in each of two databases on a common ID field in each
table.

 

[Silly Goose]

For each data table in the query, use the IN word in your
SQL query to specify the input filename.

 

[John Nurick]

Hi UB,

Do you mean a SQL query? You can use the IN clause as suggested
elsewhere - or if you're working in Access it's usually more convenient
to set up each of the tables as a linked table (File|Get External
Data|Link) and then write the query exactly as if they were ordinary
Access tables.