Microsoft® SQLXML 3.0 includes support for XPath queries that contain a cross-product in the predicate, as shown in the following example:
Customer[Order/@OrderDate=Order/@ShippedDate]
This query selects all customers with any Order for which the OrderDate equals the ShippedDate of any Order.