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

"Mariusz Stefaniak" <mariusz@stefaniak.cjb.net> a écrit dans le message de
news:ce5a8s$lva$1@achot.icm.edu.pl...
> 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
>

select a.g, a.k, a.wartosc, b.g, b.k, b.wartosc
from mytable a full outer join mytable b on a.k = b.k
where a.g = 'A' and b.g = 'B'
/

--
Regards
Michel Cadot

"Mariusz Stefaniak" <mariusz@stefaniak.cjb.net> wrote in message news:<ce5a8s$lva$1@achot.icm.edu.pl>...
> 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

What class are you taking? Have you TRIED writing anything? (even the
query that gave the "table like this" result would show you started.)

But here's the hint: In a relational DB, everything is a table. Tables
can be joined to each other. Tables can even be joined to themselves.

Let us know how you do.
Ed

>
> select a.g, a.k, a.wartosc, b.g, b.k, b.wartosc
> from mytable a full outer join mytable b on a.k = b.k
> where a.g = 'A' and b.g = 'B'
> /
>
> --
> Regards
> Michel Cadot
>
>

It's working. Thank you!
Mariusz Stefaniak