How do we join two different SQL Queries from different provider

[saivina2920]

I have two different queries.

One query (query1), i am using SQL server data. using LOAD Queries.

other query (query2), i am using Oracle data using SELECT Statement. (Oracle query is heavy and i am using select statement.

how do we join both LOAD and SELECT (SQL SERVER and ORACLE) and finally get one single query..?

Example : 

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist............

SQLTABLE1:

LOAD EmpNo.Name,Section;

SQL SELECT * from "EmpTable1";

ORACLETABLE2:

SELECT EmpNo.Name,Section where EmpNo in ('EMP101','EMP102');

How to join the above

[ajaykakkar93 · Accepted solution]

hi,

You can use previously-loaded-table / resident load to meet your requirment.

Table1:

Load * inline [

A,B

1,2

3,4

];

Table2:

Load * inline [

A,C

1,F

3,G

];

Table1Final:

A,B

resident Table1;

left join(Table1Final:);

Table2Final:

A,C

resident Table2;

drop table Table2,Table1;