I need to combine five access tables - they all containe the same field names and have a different id number as the primary key - I would like to use the info from all of the tables for queries, etc...
The following union query (union query: A query that uses the UNION operator to combine the results of two or more select queries.) selects all company names and cities from both the Suppliers and Customers tables, and sorts the data alphabetically by city.
SELECT [CompanyName], [City]
UNION SELECT [CompanyName], [City]
ORDER BY [City];