Re: Query Resultset

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 3 Jan 2007 19:11:42 +0100
Message-ID: <459bf1de$0$321$426a74cc@news.free.fr>

"Muggle" <zimpany_at_gmail.com> a écrit dans le message de news: 1167845078.116588.150960_at_48g2000cwx.googlegroups.com...
| 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
|

Search for "pivot" on Google or AskTom.

Regards
Michel Cadot Received on Wed Jan 03 2007 - 12:11:42 CST