Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Results in Parallel columns

Re: Results in Parallel columns

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 15 Jun 2006 10:18:01 -0700
Message-ID: <1150391881.628493.313770@g10g2000cwb.googlegroups.com>


>>I need to place the results of two different queries in the same result table parallel to each other. <<

This is not a table; the rows of a table model elements of a set of the same kind of thing. What you want is a display kludge to show, say, automobiles and squid as if they were the same kind of things.

Here is your kludge, since people here often gripe that I do not post the bad code the OP wants:

SELECT *, ROW_NUMBER() OVER(ORDER BY duh) AS lft_nbr FROM Foo
FULL OUTER JOIN
SELECT *, ROW_NUMBER() OVER(ORDER BY doh) AS rgt_nbr FROM Bar
ON Foo.lft_nbr = Bar.rgt_nbr;

The right way is handle display issues in the applications and front ends, not the RDBMS. Received on Thu Jun 15 2006 - 12:18:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US