Access MVP (2010-2015)
A UNION query takes data from two (or more) tables and/or queries and makes it appear as if it is from one source, i.e…
SELECT FieldName, FieldName FROM 1stTableOrQueryName UNION SELECT FieldName, FieldName FROM 2ndTableOrQueryName UNION SELECT FieldName, FieldName FROM 3ndTableOrQueryName;
A few points…
1. UNION queries are READ ONLY, no edits allowed!
2. In […]
