|
|
Posted by -CELKO- on 10/02/81 11:50
>>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.
Navigation:
[Reply to this message]
|