sql query for join two tables of different databases that are in two Servers

Question

i have two tables tableA in databaseA on ServerA and tableB in databaseB on ServerB. i just want to perform fullouter join to these tables based on common fieldname of it

Andomar · Accepted Answer · 2010-10-16 14:09:19Z

3

In SQL Server, you can create a linked server (in Management Studio, that's under Server Objects.) Then you can use a four part name to join the tables:

select  *
from    localdb.dbo.localtable as t1
full outer join
        linkedserver.remotedb.dbo.remotetable as t2
on      t1.col1 = t2.col1

If you're using another database, please edit your question to say which.

answered Oct 16, 2010 at 14:09

Andomar

239k55 gold badges387 silver badges412 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql query for join two tables of different databases that are in two Servers

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related