Re: Results in Parallel columns
From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Wed, 14 Jun 2006 15:10:59 -0700
Message-ID: <pa21925qlelc491rskcv8qss5d1jknpj1s_at_4ax.com>
Date: Wed, 14 Jun 2006 15:10:59 -0700
Message-ID: <pa21925qlelc491rskcv8qss5d1jknpj1s_at_4ax.com>
On 14 Jun 2006 14:26:00 -0700, "vivekian" <vivekaseeja_at_gmail.com> wrote:
>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
select ... into cursor one
>and the second query is
>
>1 34
>2 44
>3 98
select ... into cursor two
>the results should be displayed as
>
>1 12 34
>2 34 44
>3 45 98
select one.*,two.* from one full outer join two on one.pk=two.pkwith suitable changes for DBMS and table and column names.
>If a union is done for both the queries , we get the results in rows.
>How can the above be done.
Sincerely,
Gene Wirchenko Received on Thu Jun 15 2006 - 00:10:59 CEST