betoesquivel

xquery3

Oct 8th, 2014
538
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. SELECT idCategoria, NombreCategoria, XMLQuery(
  2. 'for $x in collection("CatalogoCD")/catalogo/cd
  3. where $x/artistas/artista/@origen = "España"
  4. return
  5.  <cd id = "{$x/@id}">
  6.    <id>{$x/@id}</id>
  7.    {$x/artistas/artista}
  8.  </cd>'
  9. PASSING CatalogoCD RETURNING CONTENT
  10. ) AS AutorEspaña
  11. FROM Categorias
Advertisement
Add Comment
Please, Sign In to add comment