Re: Juxtaposition

You might need an "order by" in each of the inline views to guarantee the order.

"Stephan Born" <stephan.born_at_beusen.de> wrote in message news:3912BEA9.D8D4199C_at_beusen.de...
> > 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
> ---------------------------------------------------------------
>
>