Return element statement : return « XQuery « XML

1. XML
2. XQuery
3. return

Return element statement

File: Data.xml


<order>
  <car model="A">
    <id>0001</id>
    <name language="en">name 1</name>
  </car>
  <car model="B">
    <id>0002</id>
    <name language="en">name 2</name>
  </car>
  <car model="B">
    <id>0003</id>
    <name language="en">name 3</name>
  </car>
</order>


File: Query.xquery

for    $car in doc("Data.xml")//car
return <car>
         <id>{$car/id}</id>
         <price>{for    $price in doc("Data.xml")//prod
                 where  $car/id = $price/@id
                 return $price/price}</price>
       </car>

Output:

<?xml version="1.0" encoding="UTF-8"?>
<car>
   <id>
      <id>0001</id>
   </id>
   <price/>
</car>
<car>
   <id>
      <id>0002</id>
   </id>
   <price/>
</car>
<car>
   <id>
      <id>0003</id>
   </id>
   <price/>
</car>

 

Related examples in the same category