title: "Query input must contain at least one table or query" error - nested queries, MS Access
body: <p>Essentially we are sometimes (?) required to provide a reference to table even if I do not need it. E.g. 
  <a href="https://stackoverflow.com/questions/16734142/query-input-must-contain-atleast-one-table-or-query">Query input must contain atleast one table or query</a></p>
  
  <p>The question I have is why query q1 <code>SELECT 1</code> executes just fine and gives me 1 row-1 column resultant table with 1 as the value but query q2 <code>SELECT * FROM q1</code> produces the aforementioned error? </p>
  
  <p>When I change q1 to <code>SELECT 1 from dummy_table</code> where dummy_table is a dummy table with dummy value, q2 runs fine.</p>
  
  <p>Why q1's internal structure is in any way relevant to q2? q1 on its own works just fine. Does the q2 "unrolls" q1 and then compiles a statement 
  <code>SELECT * FROM (SELECT 1)</code> (which on its own produces the same error). Can I somehow force Access not to peek into parents' internal structure?
  Also why <code>SELECT * FROM (SELECT 1)</code> gives an error and <code>SELECT 1</code> works fine?</p>