Query Resultset

Hello everyone,

I need to execute a complex query and I have managed to generate the following resultset

ID STATUS VALUE

1		A		value1
1		B		value2
1		C		value3
2		A		value4
2		B		value5
2		C		value6
3		A		value7
3		B		value8
3		C		value9

Using this result I want to generate the following resultset

ID ST_A ST_B ST_C

1		value1		value2		value3
2		value4		value5		value6
3		value7		value8		value9

Can I do that using a query ? Or should do it programmatically in the application that retrieves the first resultset ?

Thanks in advance
Muggle Received on Wed Jan 03 2007 - 11:24:38 CST