T-SQL Query help

Hi harishgg1,

Thank you for your reply. I know I can use "Union All" to accomplish what I want. Is there any other way I can use to accomplish this ?

Once again thank you for your reply.