02-05-2007, 02:27 PM
I am using Union to create an Recordset from multiple Tables, but I would like the Recordset to be sorted by the Tables from which they came, ie.
SELECT * FROM EmployeesUSA
UNION SELECT * FROM EmployeesEU
Sort by (create recordset from USA THEN create recordset From EU)
02-05-2007, 11:36 PM
I am unaware of any way to do this without referencing exact field names.
02-06-2007, 02:28 AM
it seems to me that you should have a single table with a single column to differentiate between the employees.
As it is you could do the following:
from tableA as sortbythis
the 'tableA' and 'tableB' are going to show up just like that. you will then sort by that column and then by the foo and bar column.
The foo, bar, qux of course represent column names where you would substitute your correct ones.