title: Adding an "auto increment id field" to a union all access-sql-query result
body: <p>Trying to add a new field "id field" to a simple union all sql query in Microsoft access like this one:</p>
  
  <pre><code>SELECT table1.name, table1.age FROM table1
  UNION ALL
  SELECT table2.name, table2.age FROM table2
  UNION ALL
  SELECT table3.name, table3.age FROM table3 
  ;
  </code></pre>
  
  <p>which starts from 1 and increment automatically , is that doable?</p>