Hi Sat,

From a discussion I had with a friend of mine:
What you need is called a pivot table. I do not think it can be achieved with SQL92.
I think however that some database servers have proprietary extensions for this
e.g. the PIVOT statement in SQL 2005 (MS SQL), and I think Oracle also has the functionality.

Dimitar