title: Joining Table via Linked Server
body: <p>I have 2 servers with 2 different databases.</p>
  
  <p>S1(Server) WITH DB1(Database) WITH T1(Table)</p>
  
  <p>and</p>
  
  <p>S2(Server) WITH DB2(Database) WITH T2(Table)</p>
  
  <p>DB1 has a linked server to S2 DB2.</p>
  
  <p>So i can run a query such as</p>
  
  <pre><code>SELECT * FROM T1 
  JOIN [S2].[DB2].[T2] T2
  ON T1.[ID] = T2.[ID]
  </code></pre>
  
  <p>And this runs correctly.</p>
  
  <p>However, how can i run it in the opposite direction</p>
  
  <p>e.g.</p>
  
  <pre><code>SELECT * FROM T2 
  JOIN [S1].[DB1].[T1] T1
  ON T2.[ID] = T1.[ID]
  </code></pre>
  
  <p>This errors with <strong>"Could not find server [S1].[DB1].[T1]"</strong></p>
  
  <p>Is there anyway i can join in this direction without having to create a linked server from S2 to S1?</p>