title: SQL JOIN with OPENQUERY
body: <p>How do I correctly join a query with a open query?
  Here is a how my query is layed out right now. The query that is part of the <code>OPENQUERY</code> works by itself.</p>
  
  <p><code>Select d.* from db.dbo.table d
  left join (select * from OPENQUERY(otherSource,'
  --working query
  SELECT...
  left join...
  inner join..') OQ
  ON d.col1 = OQ.col1
  </code></p>
  
  <p>I am catching the error <code>'Incorrect syntax near 'ON'.</code></p>