sql query

I'm beginer, plase help me

I have on my oracle 9 server, table like this:

G | K | Wartosc

A        | 1        | 0
A        | 2        | 1
A        | 3        | 1
A        | 4        | 0
B        | 1        | 1
B        | 2        | 0
B        | 3        | 0
B        | 4        | 0
B        | 5        | 1

I'd like to get data presentation like this:
G        | K       | Wartosc    | G        | K       | Wartosc    |
----------------------------------------------------------
A        | 1        | 0               | B        | 1        | 1            |
A        | 2        | 1               | B        | 2        | 0            |
A        | 3        | 1               | B        | 3        | 0            |
A        | 4        | 0               | B        | 4        | 0            |
                                         | B        | 5        | 1

Plase, help me make sql query

Thank you very much
Mariusz Received on Tue Jul 27 2004 - 05:20:14 CDT