Results in Parallel columns

From: vivekian <vivekaseeja_at_gmail.com>
Date: 14 Jun 2006 14:26:00 -0700
Message-ID: <1150320359.977336.291500_at_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 - 23:26:00 CEST

Original text of this message