Hi Chris,

Thanks, The query was working fine.

Actually i am trying the query in single statement without using UNION ALL.

So, because of that i could not able to get required output.

Once thanks again, for giving me the Solution.

Thank You,

Regards,

Nagarjun.T