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@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.pk

with 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 Wed Jun 14 2006 - 17:10:59 CDT