Robert James wrote:
> Is there anyway to tell if the records in a union came from the 1st
> query or the second?
> Can I modify the individual queries to let me know this?
You can do something like:
select 'set1' as identifier, field1, field2 from table1
union
select 'set2', field1, field2 from table2