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

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

Results in Parallel columns

From: vivekian <vivekaseeja_at_gmail.com>
Date: 14 Jun 2006 14:26:00 -0700
Message-ID: <1150320359.977336.291500@i40g2000cwc.googlegroups.com>


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

If a union is done for both the queries , we get the results in rows. How can the above be done.

Thanks in advance,
vivekian Received on Wed Jun 14 2006 - 16:26:00 CDT

Original text of this message

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