title: Query issue using Access 2007
body: <p>My query looks like this :</p>
  
  <pre><code>SELECT parent2.subid AS parent2id, parent2.sub AS parent2desc,
  key.subid AS ID, parent1.subid AS parentid, 
  parent1.sub AS parentdesc, key.sub AS key 
  FROM (table1 AS key LEFT JOIN table1 AS parent1 ON key.parent_id=parent1.subid)
  LEFT JOIN table1 AS parent2 
  ON parent1.parent_id=parent2.subid into Query_table
  </code></pre>
  
  <p>This query when run on the dB without the <code>into Query_table</code> works fine, but I want to create the table dynamically and perform some operations.</p>
  
  <p>In the above query I get the following error:</p>
  
  <blockquote>
    <p>"Syntax error (missing operator) in
    query expression
    'parent1.parent_id=parent2.subid into
    Query_tabl'"</p>
  </blockquote>
  
  <p>Any idea why?</p>