Joining tables from different JET databases: how??? 
Author Message
 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.)



Mon, 05 Nov 2001 03:00:00 GMT  
 Joining tables from different JET databases: how???
You could create a table link in one of the dbs and then just create the sql
against the one db as if the two tables were local to it.

Chuck

Quote:

>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.)



Mon, 05 Nov 2001 03:00:00 GMT  
 Joining tables from different JET databases: how???

To clarify my original inquiry:

Creating a hard link in one of the databases to the table(s) in the
other database is not an option in my situation, for reasons beyond my
control



Tue, 06 Nov 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Table join between two tables in different databases

2. Joining two tables from different databases

3. Table join between two different databases (MSSQL 6.5)

4. Join tables in different databases? SQL7

5. Join tables in different databases? SQL7

6. Importing Jet 3.51 table into Jet 4.0 database

7. Query Builder: Join table from different MDB?

8. Creating a join on tables in two different MSSQL 6.5 DB's

9. SQL problem: Joining tables in different dbases

10. Query Builder: Join table from different MDB?

11. Join Tables in different MDBs

12. HELP PLEASE: JOIN TABLES FROM DIFFERENT .MDB FILES

 

 
Powered by phpBB® Forum Software