Re: Unions in SQR

[Art DiRamio <ADiRamio@OPENSOLUTIONS.COM>]

We do it a lot. . .

The only thing about them in SQR that is different, is you don't name the
columns in your unioned select (see example).  All the other rules seem to
hold true from Oracle - same number of columns, same datatypes, etc.

Begin-Select
String1        &String1
Number2     &Number2
Date3         &Date3
String4       &String4
  From Table
Where ...

UNION

Select String1, Number2, Date3, String4
  From Table
Where...


HTH

  - - Art


                -----Original Message-----
                From:   David Fordham [mailto: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


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~