title: SQL Server Linked Server Example Query
body: <p>While in Management Studio, I am trying to run a query/do a join between two linked servers.
  Is this a correct syntax using linked db servers:</p>
  
  <pre><code>select foo.id 
  from databaseserver1.db1.table1 foo, 
       databaseserver2.db1.table1 bar 
  where foo.name=bar.name
  </code></pre>
  
  <p>Basically, do you just preface the db server name to the db.table ?</p>