how to know to which table the columns belongs

rahil_maqsood · New User Joined: 28 Mar 2005 Posts: 6

After union of two or more tables How we will come to know by seeing the resultant table which column belongs to which table

vasanthanc · New User Joined: 01 Apr 2005 Posts: 58

I think u mean to ask how to find which row is from which table as column names shud be same in all the tables u use for union

by seeing result, u cant find which table the row belongs. But to do that, u have an indirect method

Select EmpNo, EmpName, "T1" as TableName from Table1
union Select EmpNo, EmpName, "T2" as TableName from Table2

by executing the above query, u will get an additional column, which denotes which table that particular row is from.

paru · New User Joined: 24 Jun 2005 Posts: 9 Location: INDIA

Hi Vasanth

a small correction to the query u posted..
"Select EmpNo, EmpName, "T1" as TableName from Table1
union Select EmpNo, EmpName, "T2" as TableName from Table2 "

I think the correct query is
"Select EmpNo, EmpName,as "T1" from Table1
union Select EmpNo, EmpName,as "T2" from Table2

This is how i think it shud be.Corrections are welcome!

Regards,
Paru