how to join 2 table, different database and different server

jigujigu2 · #1 (**permalink**) 03-04-10, 04:12

hi, all

i have 2 tables,. same structure, but the location of the each table is different

below is the query (if same server)

Code:

SELECT  db1.dbo.table1.field_id,db2.dbo.table2.field_name 
FROM    db1.dbo.table1 INNER JOIN
                      db1.dbo.table2  ON db1.dbo.table1 =  db1.dbo.table2

the problem is the server is different computer, different IP and different authentication..how to i join that tables ?

need help.

thank's
Jigujigu

pootle flump · #2 (**permalink**) 03-04-10, 04:14

You need to create a linked server and use four part naming.

jigujigu2 · #3 (**permalink**) 03-04-10, 09:14

Quote:

Originally Posted by pootle flump

You need to create a linked server and use four part naming.

can you expland to me more detail....
i know nothing about create a linked server...

thank's
Jigujigu

pootle flump · #4 (**permalink**) 03-04-10, 09:19

sql server linked servers - Google Search

jigujigu2 · #5 (**permalink**) 03-14-10, 14:25

finally done..

thank's

Jigu

Internet Services

Web Development

Digital Marketing

Consumer Tech