Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Joining tables from 2 databases
Hello,
I have 2 databases (Access MDBs) and I need to do a select which joins a table from each database.
So I have l_rstTable1 and l_rstData2 as recordsets in my code. I need to create another recordset that is based on a join between both of the underlying tables of l_rstTable1 and l_rstTable2.
Is there an easy way to do this? I was thinking that I might need to copy one of the tables into the second database temporarily in order to do the select. Or can I make a link to one table?
The location of the databases can change and so creating the link needs to be done at run-time once the databases have been opened.
TIA
Pete
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement