Inner Join

SQL

SELECT APPLICATIONTRACKINGHISTORY01.APPLICATIONTRACKINGHISTORYNO AS APPLICATIONTRACKINGHISTORYNO01
  FROM APPLICATIONTRACKINGHISTORY APPLICATIONTRACKINGHISTORY01,
       APPLICATION                APPLICATION01,
       CSUSER                     CSUSER01
 WHERE APPLICATION01.CANDIDATENO=APPLICATIONTRACKINGHISTORY01.CANDIDATENO
   AND APPLICATION01.REQUISITIONNO =
       APPLICATIONTRACKINGHISTORY01.REQUISITIONNO
   AND APPLICATION01.PROFILELOCALE =
       APPLICATIONTRACKINGHISTORY01.PROFILELOCALE
   AND CSUSER01.CSUSERNO=APPLICATION01.CANDIDATENO
   AND ((CSUSER01.CSUSERNO) > 0)

XML query API

<query alias="testInnerJoin" projectedClass="com.taleo.akirademo.entity.ApplicationTrackingHistoryItem">
    <projections>
        <projection>
            <field path="no"/>
        </projection>
    </projections>
    <filterings>
        <filtering>
            <greaterThan><key path="application=,candidate="/>
                <integer>0</integer>
            </greaterThan>
        </filtering>
    </filterings>
</query>