Is there a way to tell from what table the elemnt is coming from in a UNION quer

[onedumbcoder]

lets say i have

 

select a from 1

union

select a from 2

 

 

is there a way to tell what table a is coming from?

[onedumbcoder]

for example when i am going through the list and printing out the values that have been returned is there any way to tell where that value came from whether it came from 1 or 2

[Mark Baker]

SELECT 'table_1' as sourceTable
        column_a
  FROM table_1
UNION
SELECT 'table_2' as sourceTable
        column_a
  FROM table_2

 

[onedumbcoder]

wow thanks my friend!!!!!!! that helps me out so much