title: Have a subquery inside the FROM part of query use info from another table inside the same FROM table list
body: <p>I don't know if I've explained it well enough, but I think I have an odd problem here.</p>
  
  <p>I need to use my two queries as tables such as </p>
  
  <pre><code>SELECT * 
  FROM (SELECT ...) query1, 
       (SELECT * ... FROM ... WHERE query1.col = mycol) query 2,
       table1 table1,
       table2 table2,
  WHERE query1.something = table1.something
  AND query1.otherthing = query2.otherthing
  AND query2.something = table1.something
  AND query.otherthing = table2.otherthing
  </code></pre>
  
  <p>Is something like this possible without nesting query1 again as a subquery into query2?</p>