topic Inner join on 2 Databases.. in QlikView

Inner join on 2 Databases..

Tue, 30 Jun 2009 14:47:23 GMT

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?

AW:Inner join on 2 Databases..

Tue, 30 Jun 2009 16:58:23 GMT

Hi,

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

The correct code is:

"Tablename":

SELECT * FROM Table1;

INNER JOIN SELECT * FROM Table2;

AW:Inner join on 2 Databases..

Tue, 30 Jun 2009 17:03:21 GMT

No,

i have two databases,

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

AW:Re: AW:Inner join on 2 Databases..

Tue, 30 Jun 2009 18:13:12 GMT

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;