title: How to join linked server tables with openquery
body: <p>I want to join tables from two different linked servers. I am  not sure how to do that.   </p>
  
  <p>First query:</p>
  
  <pre><code>SELECT * FROM OPENQUERY(PANTS,'
  SELECT
  LONG
  ,SHORT
  FROM JEANS
  </code></pre>
  
  <p>Second query:</p>
  
  <pre><code>SELECT * FROM OPENQUERY(SHIRTS,'
  SELECT 
  WHITE
  ,BLACK 
   FROM STORES
  </code></pre>
  
  <p>Let's say long is in the <code>stores</code> table and I want to join on it. How would I do that?</p>