
Joining tables from different JET databases: how???
I am trying to construct an SQL SELECT statement, for use with DAO, that
joins tables that reside in separate .MDB databases.
The syntax "SELECT ... FROM table1, table2 IN externaldatabase" appears
to require that _both_ table1 and table2 reside in the external
database; i.e., they must both be in the same database. So this doesn't
seem to do the trick.
What would be the proper syntax/constuction to join tables from
different databases? (Seems like this sort of thing should be fairly
straightforward, but can't seem to get a handle on it.)