How to merge multiple resultset into one column in sql server ?

Ranjeet_8
Posted by Ranjeet_8 under Sql Server category on | Points: 40 | Views : 1398

SELECT Column_Name as Result FROM Table_1
UNION ALL
SELECT Column_Name FROM Table_2
UNION ALL
SELECT Column_Name FROM Table_3

Comments or Responses

Posted by: Jasminej on: 10/23/2012 Level:Starter | Status: [Member] | Points: 10
Question and answer is something messing up!

The question should be like "How to merge multiple resultset into one"!

But, the question is different and the answer is different. Kindly check and update accordingly!

Do you agree this ?

thank you
Posted by: Sourabh07 on: 10/23/2012 Level:Starter | Status: [Member] | Points: 10
hi ranjeet...

I think question must be like "How to merge multiple tables into one excluding duplicate rows?".

Regards,
Sourabh
Posted by: Ranjeet_8 on: 10/23/2012 Level:Gold | Status: [Member] [MVP] | Points: 10
@Jasminej
Thanks.

Login to post response