Table JOIN across subnets

• Magy

  SSCarpal Tunnel

  Points: 4217

  More actions

  July 11, 2007 at 12:13 pm

  #173448

  Is it possible to do a JOIN on a table that is in a database that resides on a server on a different subnet?

  Thanks

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  July 11, 2007 at 12:44 pm

  #718749

  Sure, it's possible.  You can setup the other server as a linked server, then write your query using that 4 part name for the linked server table.

  
  
  Mark