Vignesh Kumar

Vignesh Kumar

  • NA
  • 1k
  • 418.5k

Establishing Connection?

Sep 6 2013 3:08 AM
Hi,

I have two tables tableA in databaseA on ServerA and tableB in databaseB on ServerB. I want to perform join to these tables. I written query for this, since I don't have access to these servers. So prior to this I want to establish a connection between two servers.

select  * from    localdb.dbo.localtable as t1
full outer join

linkedserver
.remotedb.dbo.remotetable as t2
on t1.col1 = t2.col1


Answers (2)