473,399 Members | 2,278 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

Table join from different servers

Is it possible to obtain data from two different databased, each being on a
different server. How would the query be written?

example:

TABLE1 on SERVER1 db1name/db1pass@instance1
TABLE2 on SERVER2 db2name/db2pass@instance2

TABLE1
--------------------
column_a1
column_b1
column_c1

TABLE2
---------------------
column_a2
column_b2
column_c2
TABLE JOIN:
column_a1 column_a2 column_b2 column_c1
----------- ------------ ------------ -------------
apple fruit red tree
orange fruit orange tree
grape fruit purple vine
pumpkin vegetable orange vine
Feb 25 '07 #1
1 3350
JustAQTCub wrote:
Is it possible to obtain data from two different databased, each being on a
different server. How would the query be written?

example:

TABLE1 on SERVER1 db1name/db1pass@instance1
TABLE2 on SERVER2 db2name/db2pass@instance2

TABLE1
--------------------
column_a1
column_b1
column_c1

TABLE2
---------------------
column_a2
column_b2
column_c2
TABLE JOIN:
column_a1 column_a2 column_b2 column_c1
----------- ------------ ------------ -------------
apple fruit red tree
orange fruit orange tree
grape fruit purple vine
pumpkin vegetable orange vine

why not establish a database link then just refernce the othertable@your
link?
May 21 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: djc | last post by:
I need to use data from multiple tables that are located in 2 different databases. Most of the tables are in SQL Server 2000 but 1 one the tables I need to include in my query resides in an...
7
by: steve | last post by:
Can you join two tables across different servers in mySQL, or am I dreaming of Oracle? -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked...
8
by: Ootyguy | last post by:
Trying to do this all day and googling for answers but found none, hope someone can help. Thanks in advance. select * into OPENROWSET('SQLOLEDB','SERVER';'uid';'pwd',##test) from LocalTable ...
2
by: bodleyhenley | last post by:
Please help me with this! :) I have a database of servers, one of the things I am recording information about is what software is on each server. Obviously this is a many to many so I have a...
2
by: mmitchell_houston | last post by:
I'm working on a .NET project and I need a single query to return a result set from three related tables in Access 2003, and I'm having trouble getting the results I want. The details: ...
5
by: Regnab | last post by:
I have a table "tblSprayApplication" in a project for a nursery. Each record refers to a single spray application across the nursery, recording which groups had been sprayed. Multiple applications...
40
by: rdemyan via AccessMonster.com | last post by:
I have two databases, db1 and db2, with the same table, TableA. I want to select the records from TableA in db1 that have a LAST_UPDATE SomeDate. Then I want to get the identical records in TableA...
2
by: banem | last post by:
Hello, It is a bit tricky to explain, but I will try with sample. I have one table: ID, server 1, server1 2, server2 3, server1 4, server3 5, server4
2
by: Gilbert Tordeur | last post by:
Hello, I work with VB2008 and SQL Server 2000. I would like to make a JOIN between to SQL tables that are stored on different servers. How should I write the LINQ statement(s) ? Thank you...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.