Re: Outer Joins in SQR

[Art DiRamio <ADiRamio@OPENSOLUTIONS.COM>]

Works fine for us here (Oracle / SQR 3x and 4x)

Are you sure you are outer joining the proper table?  Remember, outer joins
get everything from one table and the corresponding 'available' data from
the other.  Check the driving table. . .

  - - Art  :-)


        -----Original Message-----
        From:   Hope, Sandra [SMTP:HopeS@DYNCORP.COM]
        Sent:   Monday, November 09, 1998 4:11 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        Outer Joins in SQR

        Any tips on doing an outer join in an SQR (Oracle)? I've tried using
the (+)
        in my select statements, but it doesn't work.


        Sandra Hope
        DynCorp
        hopes@dyncorp.com
        Office:   (703) 715-4428
        RESYSTEMIZATION
        PeopleSoft