I Want To Combine/union Two Tables And Have It Create A Field That Identifies Which Table It Came From

I want to combine/union two tables and have it create a field that identifies which table it came from. I saw an answer for SQL but I do not need max values. I just need to Union t

Solution 1:

You can just add in the column as a constant:

SELECT "TableA" as which, [TableA].[1As], [TableA].[2As]
FROM TableA
UNION ALL
SELECT "TableB", [TableB].[1As], [TableB].[2As]
FROM TableB