[AccessD] Combine two tables

I thought so too Arthur, but apparently, the tables have the same name -- is 
this correct Lembit?

Susan H.


> The simplest way to do this is to embed the table name as a literal in 
> both
> queries:
>
> SELECT CustomerID, CustomerName, "Table1" FROM somewhere
> UNION
> SELECT CustomerID, CustomerName, "Table2" FROM somewhere