Overview of the Procedure

  1. Add the remote servers to the interfaces file.

  2. Define each remote server using sp_addserver.

  3. Map the remote tables to the server using create existing table.

  4. Perform the join using select.