|
|
Posted by Gene Wirchenko on 06/14/06 22:10
On 14 Jun 2006 14:26:00 -0700, "vivekian" <vivekaseeja@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
Navigation:
[Reply to this message]
|