topic Re: Join table from one SQL connection to other SQL connection in QlikView

Join table from one SQL connection to other SQL connection

Sakura — Tue, 26 Sep 2017 13:49:23 GMT

I want to join one table from one sql connection to other.

What I did is like :

---------------------------------------

Plant:

sql select Plantcode, Keyid from plants

ODBC CONNECT 32 TO SQLConnection2

Right join(Plant)

query2:

select Keyid, * from table1

---------------------------------

I have to get plantcode from plants to query2. This code is not working. Please help!!

Re: Join table from one SQL connection to other SQL connection

Anil_Babu_Samineni — Tue, 26 Sep 2017 13:52:52 GMT

Where is the first connection, And cnnection always shold start from first line (I meant you have to declare before SELECT statement) or else please post full script

Re: Join table from one SQL connection to other SQL connection

Sakura — Tue, 26 Sep 2017 14:06:16 GMT

Apologies Anil but I cannot post the qvw. The script is really big and the connection is defined above the 1st query.

---------------------------------------

ODBC CONNECT 32 TO SQLConnection1

Plant:

sql select Plantcode, Keyid from plants

ODBC CONNECT 32 TO SQLConnection2

Right join(Plant)

query2:

select Keyid, * from table1

---------------------------------

Re: Join table from one SQL connection to other SQL connection

Anil_Babu_Samineni — Tue, 26 Sep 2017 14:33:41 GMT

What if you load second connection into first one

ODBC CONNECT 32 TO SQLConnection2;

ODBC CONNECT 32 TO SQLConnection1;

query2:

select Keyid, * from table1;

Right join(Plant)

Plant:

sql select Plantcode, Keyid from plants