title: Want to add a New column in MS Access query via SQL
body: <p>I have 3 tables they all have the same column header Name, Number I have joined them using the union command as shown below:</p>
  
  <pre><code>SELECT Name, Number
  FROM table1
  Union all
  select name, number
  from table2
  UNION ALL select name, number
  from table3;
  </code></pre>
  
  <p>Every thing is right up till here. Now I want to add a new column which should contain the information about from which table this data have been taken. I am using the alter table command but it gives error.</p>
  
  <p>Kindly help me. I am working on MS access 2007.</p>