Complex Collections - More than one foreign key

[Prateek Asthana]

Hi,
Below snippet helps us retrieve data from two tables linked by a
single foreign key.

<resultMap id="ResultOrderInfoMap"
class="org.apache.mapper2.examples.bean.OrderInfo">
        <result property="order.orderId" column="orderId" />
        <result property="orderItemList" column="orderId"
select="Ch6.getOrderItemList" />
</resultMap>


<resultMap id="ResultOrderItemMap"
class="org.apache.mapper2.examples.bean.OrderItem">
        <result property="orderId" column="orderId" />
        <result property="orderItemId" column="orderItemId" />
</resultMap>


<select id="getOrderInfoList" resultMap="ResultOrderInfoMap">
        select orderId from orders where accountId = #value#
</select>


<select id="getOrderItemList" resultMap="ResultOrderItemMap">
        select orderId, orderItemId from orderItem
        where orderid = #value#
</select>


In above case, records from both table are retrieved using
orderItem.orderId=orders.orderId; This case has only has one foreign
key constrant;

If the scenario involved two columns as foreign key constraints i.e
orderItem.orderId=orders.orderId AND orderItem.origin=orders.origin
then how could we specify that ?

Thanks
Prateek