Outer Join used in query
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 (