I am trying to query several tables that have the same 3 columns and combine the results like this.
Select col1,col2,col3 from tblA
Select col1,col2,col3 from tblB
Select col1,col2,col3, from tblC
The end result who not only show me the union of three columns form all the tables but also - which is there source table as well like this
Col1 | col2 | col3 | myTableName
Er | ty | rt } tblA
Er | ty | rt } tblB