Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2009
    Posts
    17

    Unanswered: how to join 2 table, different database and different server

    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

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You need to create a linked server and use four part naming.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Nov 2009
    Posts
    17
    Quote Originally Posted by pootle flump View Post
    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

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Nov 2009
    Posts
    17
    finally done..

    thank's

    Jigu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •