Intersect

SQL

SELECT CSUSER01.CSUSERNO AS entityKey
  FROM CSUSER CSUSER01
 WHERE (CSUSER01.FIRSTNAME LIKE 'a%' ESCAPE '\')
INTERSECT
SELECT CSUSER02.CSUSERNO AS entityKey
  FROM CSUSER CSUSER02
 WHERE (CSUSER02.FIRSTNAME LIKE 's%' ESCAPE '\')

XML query API

<intersect alias="testIntersect">
    <queries>
        <query alias="testIntersect2" projectedClass="com.taleo.akirademo.entity.Candidate">
            <projections>
                <projection alias="entityKey" tag="entityKey">
                    <key path=""/>
                </projection>
            </projections>
            <filterings>
                <filtering>
                    <matches>
                        <field path="firstName"/>
                        <string>a*</string>
                    </matches>
                </filtering>
            </filterings>
        </query>
        <query alias="candidateSubQuery" projectedClass="com.taleo.akirademo.entity.Candidate">
            <projections>
                <projection alias="entityKey" tag="entityKey">
                    <key path=""/>
                </projection>
            </projections>
            <filterings>
                <filtering>
                    <matches>
                        <field path="firstName"/>
                        <string>s*</string>
                    </matches>
                </filtering>
            </filterings>
        </query>
    </queries>
</intersect>