Hey Damien,

You are a champion. This is exatly what I want. Why it did not come to my mind... A very big and heavy thanks to you.

I would...

Thanks Damien for your reply.

But, I cannot use union all as there would be duplicate rows all three result sets and only the last column (marks - col3) would...