Re: Results in Parallel columns
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 15 Jun 2006 10:18:01 -0700
Message-ID: <1150391881.628493.313770_at_g10g2000cwb.googlegroups.com>
Date: 15 Jun 2006 10:18:01 -0700
Message-ID: <1150391881.628493.313770_at_g10g2000cwb.googlegroups.com>
>>I need to place the results of two different queries in the same result table parallel to each other. <<
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 - 19:18:01 CEST