Is it True that can't join tables from different servers?

edited August 2017

According to this, it's not possible. If it is, what is the syntax? I have a connection that used additional linked servers but don't know how to differentiate primary connection and additional one when it is a different server

from p in TableInPrimaryServer join r in TableInSecondaryServer.RM00101s on p.PHONE equals r.PHONE1


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!