PL/SQL (MOSC)

MOSC Banner

Outer Join used in query

edited Jan 29, 2019 4:02AM in PL/SQL (MOSC) 11 commentsAnswered

Hi Friends,

In our data base have query as mention below, here outer join used by two time, my question is can we make single Left Outer join an dput "Package_type in " 'F', 'R') ""

SELECT  COUNT(odpreevent0_.Id) AS col_0_0_

FROM    prod.OD_PRE_EVENT odpreevent0_

        LEFT OUTER JOIN prod.OD_PRE_EVENT_PACKAGE odpreevent1_

        ON      odpreevent0_.Id=odpreevent1_.PRE_EVENT_ID

                AND

                (

                        odpreevent1_.PACKAGE_TYPE='F'

                )

        LEFT OUTER JOIN prod.OD_PRE_EVENT_PACKAGE odpreevent2_

        ON      odpreevent0_.Id=odpreevent2_.PRE_EVENT_ID

                AND

                (

                        odpreevent2_.PACKAGE_TYPE='R'

                )

WHERE   1=1

        AND

        (

                odpreevent0_.CONCESSION_ID IN (:1 )

        )

        AND

        (

                odpreevent0_.PLAZA_ID IN (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center