Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql query
"Mariusz Stefaniak" <mariusz_at_stefaniak.cjb.net> a écrit dans le message de
news:ce5a8s$lva$1_at_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 CadotReceived on Tue Jul 27 2004 - 12:53:04 CDT