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.
All the data types and field sizes line up properly.
What else do I need to do to make this UNION query work?
This is the current SQL behind the query:
SELECT * FROM MappingQuery1 UNION SELECT * FROM MappingQuery2;
An answer below posted a link to a KB article that states with certainty that the data in a
UNION query can't be updated. Is there any way I can work around this? For example:
SELECT * FROM MappingQuery1, MappingQuery2;
Will this work? Remember, all the fields are aligned in type, size, and name.