title: Can we make middle table to simplify query
body: <p>With the below query, I am creating a new table.</p>
  
  <pre><code>select * from TableA, tableB, (another query to make new table)TableC
  where condition
  </code></pre>
  
  <p>This makes my query look long and awful. I don't know if there is a way to make a temporary table to query later.</p>
  
  <p>For example based on the above query:</p>
  
  <pre><code>tableC = another query to make new table
  select * from tableA, tableB, tableC
  where condition
  </code></pre>