Inner join on 2 Databases..

[#1]

Good Morning,

i have to create an INNER JOIN between 2 databases....

I have tried to do this operation with the nornal SQL language, but when i launch the script it's give me an error.

What is the correct form to do an INNER JOIN between two databases?

[#2]

Hi,

i think, you mean to join two tables, not databases.

The correct code is:

"Tablename":

SELECT * FROM Table1;

INNER JOIN SELECT * FROM Table2;

[#3]

No,

i have two databases,

and i have to connect the tables A in DB1.mdb with the tables B in DB2.mdb...

[#4]

Ok, it´s the same for different databases:

"Test":
ODBC CONNECT TO [MS Access Database;DBQ=db1.mdb];
SQL SELECT
ID,
Feld1
FROM Tabelle1;
Disconnect;
LEFT JOIN
ODBC CONNECT TO [MS Access Database;DBQ=db2.mdb];
SQL SELECT
ID,
Feld1
FROM Tabelle1;