File: order.xml
0001
name 1
navy black
0002
name 2
0003
name 3
File: inventory.xml
File: Query.xquery
for $car in doc("inventory.xml")//car,
$car in doc("order.xml")//car,
$price in doc("prices.xml")//prices/priceList/prod
where $car/@id = $car/id and $car/id = $price/@id
return
price="{$price/price}"/>