Re: Juxtaposition

From: Stephan Born <stephan.born_at_beusen.de>
Date: 2000/05/05
Message-ID: <3912BEA9.D8D4199C@beusen.de>#1/1

> Hello every one,
>
> I have two tables T1 and T2
>
> T1 a
> ------
> 1
> 2
>
> T2 b
> ------
> a
> b
>
> What this the SQL query (not PLSQL query) that can yields
>
> T a b
> -------
> 1 a
> 2 b
>
> Thank u in advance

Try

select

    tab1.*, tab2.*
from

    (

        select rownum rn, t_1.*
        from t1 t_1

    ) tab1,
    (

        select rownum rn, t_2.*
        from t2 t_2

    ) tab2
where tab1.rn = tab2.rn

May be that you can use this statement for your needs....

Let me know,

regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-21          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------

Received on Fri May 05 2000 - 00:00:00 CDT