Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Results in Parallel columns

Re: Results in Parallel columns

From: <pietlinden_at_hotmail.com>
Date: 14 Jun 2006 15:03:25 -0700
Message-ID: <1150322605.380447.175340@y41g2000cwy.googlegroups.com>

vivekian wrote:
> Hi ,
>
> I need to place the results of two different queries in the same result
> table parallel to each other.
> So if the result of the first query is
>
> 1 12
> 2 34
> 3 45
>
> and the second query is
>
> 1 34
> 2 44
> 3 98
>
> the results should be displayed as
>
> 1 12 34
> 2 34 44
> 3 45 98
>

SELECT qry1.fld1 As FirstField, qry1.fld2 As SecondField, qry2.fild2 as ThirdField
FROM qry1 INNER JOIN qry2 ON qry1.Field1=qry2.fld1 ORDER BY FirstField Received on Wed Jun 14 2006 - 17:03:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US