return table name also

[Kaz888]

I am using a SELECT UNION ALL query.

The query looks at 6 specific tables and returns the records in each table that have a status of 1.

At present, the query returns a list of records(sometimes only 2 records), but I then need to go into each of the tables to identify them eg one is an invoice, one is a cheque.

How can I get the table name to show for each record?
Or am I better of separating the query and running them individually?

Thanks in advance,

Kaz

 

[cheerio]

Just build the table name into the query!

SELECT "Table1" as TableName, field1, ...
FROM Table1

UNION

SELECT "Table2" as TableName, field1, ...
FROM Table2


Ken

 

[Kaz888]

Thankyou Ken

Works a treat!

I should have posted to the forum earlier,
instead of wasting 2 days.

Many thanks

Kaz