join across servers

Community Support
1

Here is a join query I want to run:

(colA xkey (select colA,colB from T1))lj colA xkey (select colA,colC from T2)

Problem is table T1 is on server A, and table T2 is on server B and say the query is running on server A.

I can of course open up a handle to server B, execute select colA,colC from T2 to get the table over to server A and then run the join, possibly get more clever and only retrieve rows where there is a match.

But what I am wondering is - is there a way to do this more directly than opening a handle and running a query remotely via IPC?

Great would be:

(colA xkey (select colA,colB from T1))lj colA xkey (select colA,colC from ServerB.T2)

–?

Tahsin Alam
alam.tahsin@gmail.com

2

there has to be IPC in there somewhere.
If you wanted to hide the complexity you can wrap the ipc call into a function so it becomes something like:

(select colA,colC from GetData[ServerB;T2])