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

Question

Hi all How to combine the two columns having different name from two different tables in SQL Server ?

Shankar M · Answer

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

Rohatash Kumar · Answer

Thanks sivaraman But Column name are not same in both table.

Sivaraman Dhamodaran · Answer

Select column in first table Select column in second table and Union them. Google SQL2005 Select Union

nallya · Answer

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