...> </root> So in this case what I need to do is select all of the items from the matchItems node where canBuy='True' and join that with //buyItems/item/doBuy='true' on the programKey. A straight up inner join on criteria. In this case I should only get one item key back: DERTH. In the sample query that I posted I'd get all of the items back. My plan B on ...

...> </buyItems> </root> So in this case what I need to do is select all of the items from the matchItems node where canBuy='True' and join that with //buyItems/item/doBuy='true' on the programKey. A straight up inner join on criteria. In this case I should only get one item key back: DERTH. In the sample query that I posted I'd get all of the items back. My plan B ...

...> </item> </buyItems> </root> So in this case what I need to do is select all of the items from the matchItems node where canBuy='True' and join that with //buyItems/item/doBuy='true' on the programKey. A straight up inner join on criteria. In this case I should only get one item key back: DERTH. In the sample query that I posted I'd get all of the items back. My plan B on ...