How can I select a Field and then add that field as a column?

Dialect: SQL 92
I have a table eg

employee type value
001 salary 1500.23
001 expenses 120.00
002 salary 1600.50
003 salary 1600
003 bonus 300

And want the table to look like

Employee salary expenses bonus
001 1500.23 120 0

Any ideas

Thanks

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