Question:
How to join tables from different servers using SQL ?
security
2008-06-01 04:55:11 UTC
How to join tables from different servers using SQL ?
Three answers:
Serge M
2008-06-01 09:28:28 UTC
Use the following syntax:



...

JOIN

...


ON <...>
i♥u2
2008-06-01 05:33:39 UTC
You can't do it.

You must first use SQL to get the data from tables to the same server before you can use the join statement.
Eric20FL
2008-06-01 07:55:21 UTC
Use linked servers. See the link below for syntax.



I use it all the time.


ⓘ
This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...