Re: Outer Joins in SQR

["Singh, Rajvirendra NY ESA" <RajvirendraSingh@EXCHANGE.ML.COM>]

Hi Sandra,

If you have more than two table join then following code may help you.

Select T1.a, T2.b, T3.c
>From T1, T2, T3
Where T1.a = T2.a(+)
and T2.b = T3.b(+)

In above example T2 and T3 always has match even though  you need to put
outer join to make first outer join working.

Thanks

Rajvirendra Singh



        -----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