Solved

I want to join 2 tables from 2 different servers

Posted on 2007-04-03
3
226 Views
Last Modified: 2010-07-27
I want to join 2 tables from 2 different servers.  I envisioned something like:

SELECT *
FROM Server1.Datebase.table t1 LEFT JOIN Server2.Database.table t2 ON t1.Index = t2.Index

Can this be done in t-sql?
0
Comment
Question by:jamesrbarnes
3 Comments
 
LVL 21

Assisted Solution

by:Kevin3NF
Kevin3NF earned 100 total points
ID: 18843923
You need to set up the "other" server as a linked server.  Check out sp_addlinkedserver in Books Online, or look in the GUI for the version you are using...which is what...2000 or 2005?
0
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 300 total points
ID: 18844013
yes linked server
and 4 part naming

Servername.Datebasename.ownername.tablevieworfunctionName
0
 
LVL 2

Assisted Solution

by:poogy21
poogy21 earned 100 total points
ID: 18849202
yes. setup a "linked server" and you could do exactly that.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question