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 ,
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