If this is in reference to your previous question, the answer is just as
Karl gave it.  You must explicitly name the table.  There's no "automatic"
way to do it.  It would look something like this:

SELECT "table1" As TableName, * FROM Table1
Union
SELECT "table2"As TableName, * FROM Table2
UNION
SELECT "table3"As TableName, * FROM Table3;

As a side note, if you want specific answers, it would be better to ask
specific questions, listing the actual table and field names that you're
using.  It will avoid a lot of confusion and folks will be more willing to
look at your questions.