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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
