Adding the Two Columns having Different Name from Two Different Tables in SQL Server

Hi Rohatash,

No problem, if two column names are different and if you are trying to union them, The only issue is that both should of same datatype.

Thanks,
Shankar

0

Rohatash Kumar14y ago

Thanks sivaraman,

But Column name are not same in both table.

0

Sivaraman Dhamodaran14y ago

Select column in first table,
Select column in second table and Union them.

Google SQL2005 Select Union

0

nallya14y ago

Refer This:

http://stackoverflow.com/questions/2360396/how-can-i-merge-the-columns-from-two-tables-into-one-output

0