Re: Unions in SQR

[John Milardovic <milardj@SX.COM>]

Hi David.

I've done it in a couple of reports using the format:

begin-select
col 1 (+1,1)
col 2 (,20)
col 3 (,40)
from (
        select col 1,
                        col 2.
                        col 3
        from x
        union
        select col 1,
                        col 2,
                  col 3)

HTH
John Milardovic





> -----Original Message-----
> From: David Fordham [SMTP:dfordham@SUMMITTECH.COM]
> Sent: Wednesday, November 03, 1999 2:41 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Unions in SQR
>
> Hi all,
>
> Anyone ever have eny luck doing an Oracle union in an SQR??   I have tried
> all day to get this to work but to no avail.
>
> TIA,
>
> David Fordham
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>          S U M M I T   T E C H N O L O G I E S,  I N C.
>
> http://www.summittech.com             dfordham@summittech.com
> 8921 E Chenango Ave                   303.740.8791
> Greenwood Village, CO  80111          888.833.7360  Toll Free
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~