Selecting the Tablename in a UNION

[jl8789]

First post in this forum, so please help and be kind!

I have a UNION of two different tables that basically contain the same information. What I want to know is how can I select the tablename from the query so when I display the results I know which table the row came from?

Thanks!

 

[Mercury2]

Insert literally the table name on every select stm, that is:

select fld1, fld2, ..., 'TABLE1' from table1
union
select fld1, fld2, ..., 'TABLE2' from table2

It's that simple !

 

[jl8789]

Thanks. I finally did that, I was trying to think too hard for something so simple.