Results in Parallel columns

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