Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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
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
---------------------------------
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