Contents

let $highbid := max(doc("bids.xml")//bid_tuple/bid)
return
    <result>
     {
        for $item in doc("items.xml")//item_tuple,
            $b in doc("bids.xml")//bid_tuple[itemno = $item/itemno]
        where $b/bid = $highbid
        return
            <expensive_item>
                { $item/itemno }
                { $item/description }
                <high_bid>{ $highbid }</high_bid>
            </expensive_item>
     }
    </result>

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
magic_xml-0.1.1	xquery_use_cases/rdb/q11.xquery
magic_xml-0.1.0	xquery_use_cases/rdb/q11.xquery