SQL JOIN with OPENQUERY
<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>