Contents

<result>
  {
    for $u in doc("users.xml")//user_tuple
    let $b := doc("bids.xml")//bid_tuple[userid = $u/userid]
    order by $u/userid
    return
        <user>
            { $u/userid }
            { $u/name }
            {
                if (empty($b))
                  then <status>inactive</status>
                  else <status>active</status>
            }
        </user>
  }
</result>

Version data entries

2 entries across 2 versions & 1 rubygems

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