Adding Field to Query

[David44Coder]

I have made a Union query showing various fields from 4 different tables
Is it possible to add a field showing the Names of each table into just the query? That is without adding a Name field into each table ?

 

[sonic8]

Sure. You can add each table name as a constant field into the query.

SELECT *, 'Table1' AS SourceTable FROM Table1
UNION
SELECT *, 'Table2' AS SourceTable FROM Table2