Query that joins two documents

For each book found in both bib.xml and reveiws.xml, list the title of the book and its price from each source.

   FOR $b IN document("bib.xml")//book,
     $a IN document("reviews.xml")//entry
   WHERE $b/title = $a/title
     { $b/title },
       <price-amazon> { $a/price/text() } </price-amazon>
       <price-bn> { $b/price/text() } </price-bn>

Adapted from XML Query Use Cases

Previous | Next | Top | Cafe con Leche

Copyright 2000, 2001 Elliotte Rusty Harold
Last Modified September 13, 2001