( FOR $highbid IN document("bids.xml")//bid_tuple, $user IN document("users.xml")//user_tuple WHERE $user/userid = $highbid/userid AND $highbid/bid = ( LET $b := document("bids.xml")/bid_tuple [itemno = $highbid/itemno] RETURN max($b/bid) ) RETURN $highbid/itemno , $highbid/bid , $user/name/text() SORTBY (itemno) )