Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT idCategoria, NombreCategoria, XMLQuery(
- 'for $x in collection("CatalogoCD")/catalogo/cd
- where $x/precio >= 150
- return
- <cd id="{$x/@id}">
- <titulo> {$x/titulo}</titulo>
- <año> {$x/año}</año>
- </cd>'
- PASSING CatalogoCD RETURNING CONTENT
- ) AS CDS
- FROM Categorias
- WHERE idCategoria > 15 AND idCategoria < 25
Advertisement
Add Comment
Please, Sign In to add comment