title: How do I make an editable UNION query?
body: <p>In the course of a complex database structure, I need to provide the user with a means of editing data stored in a series of tables.  Although all the data types are the same, they don't line up 1:1 in their names.  To alleviate this, I created a query that maps the original names (which come from outside reports) to the internally-used names; from these queries, everything is fed into one giant UNION query.</p>
  
  <p>All the data types and field sizes line up properly.</p>
  
  <p>What else do I need to do to make this UNION query work?</p>
  
  <p>This is the current SQL behind the query:</p>
  
  <pre><code>SELECT * FROM MappingQuery1 UNION SELECT * FROM MappingQuery2;
  </code></pre>
  
  <p>EDIT:</p>
  
  <p>An answer below posted a link to a <a href="http://support.microsoft.com/kb/328828" rel="nofollow noreferrer">KB article</a> that states with certainty that the data in a <code>UNION</code> query can't be updated.  Is there any way I can work around this? For example:</p>
  
  <pre><code>SELECT * FROM MappingQuery1, MappingQuery2;
  </code></pre>
  
  <p>Will this work?  Remember, all the fields are aligned in type, size, and name.</p>