How can I join two tables from two different connections or instances in SQL Server?

Asked Jul 13 '18 at 12:19

Active Jul 13 '18 at 12:29

Viewed 62 times

How to join two tables from different connections / instances in SQL Server?

Something like this :

select * 
from [connection1].[database].[table] c1
join [connection2].[database].[table] c2 on c1.id = c2.id

edited Jul 13 '18 at 12:29

marc_s

asked Jul 13 '18 at 12:19

Hisen

1

Please find the format [`...`](https://stackoverflow.com/a/4091984/2451726)
– Arulkumar Jul 13 '18 at 12:24
check out making linked servers – sniperd Jul 13 '18 at 13:20
hi guys. I found the solution and its worked for me : http://txt.do/dzpcu – Hisen Jul 13 '18 at 16:53

0 Answers0