SELECT statement to write

[amarg]

Hi,

I am having following data.

GROUP
----------------------------------------------
ID TYPE VALUE
----------------------------------------------
01 D D01
01 P P02
01 F F03
01 P P01
01 F F01
02 P P10
02 P P02
03 D D01
-----------------------------------------------

What select should bring back :

INPUT OUTPUT
(P01, D01, F01) 01,03
(P02, * , F03) 01,02
(P10, * , * ) 02
(P02, * , * ) 02
(*, D01, * ) 03
(P01, D01, * ) null
------------------------------------------------

Note: * means any non matching value.


Please let me know if someone need more information.

Reards & thanks
Amar Deep Gaur