Outer Join

SQL

SELECT APPLICATION01.CANDIDATENO AS CANDIDATENO01
  FROM APPLICATIONTRACKINGHISTORY APPLICATIONTRACKINGHISTORY01,
       APPLICATION                APPLICATION01
 WHERE APPLICATION01.CANDIDATENO(+) =
       APPLICATIONTRACKINGHISTORY01.CANDIDATENO
   AND APPLICATION01.REQUISITIONNO(+) =
       APPLICATIONTRACKINGHISTORY01.REQUISITIONNO
   AND APPLICATION01.PROFILELOCALE(+) =
       APPLICATIONTRACKINGHISTORY01.PROFILELOCALE

XML query API

<query alias="testOuterJoin" projectedClass="com.taleo.akirademo.entity.ApplicationTrackingHistoryItem">
    <projections>
        <projection>
            <field path="application+,candidate+"/>
        </projection>
    </projections>
</query>