 <p>Try the following:</p> <pre><code>SELECT myTable1.* FROM myTable1 JOIN (SELECT myTable2.* FROM myTable2) b ON myTable1.myRef = b.myRef WHERE col2 = 1 ORDER BY b.col3 ASC </code></pre> <blockquote> <p>If your <em>WHERE</em> statement is referecing <em>col2</em> correctly, this approach should work just fine.</p> </blockquote>