Selection:

Name: result

Simple Content:

Iteration: $k in document("statisticsDB.xml")/statisticsDB/*

Filter: local-name( $k ) = 'cityStatistics' and $k/organization/cid = $k/financial/aid

Order:




Selection:

Name:

Simple Content:

Iteration: $i in $k/*

Filter: local-name( $i ) = 'organization' or local-name( $i ) = 'financial'

Order:



Selection: local-name( $i ) = 'organization'

Name:

Simple Content:

Iteration: $j in $i/*

Filter: local-name( $j ) = 'cid'

Order:




Selection:

Name:

Simple Content: $j

Iteration:

Filter:

Order:



Selection: local-name( $i ) = 'financial'

Name:

Simple Content:

Iteration: $j in $i/*

Filter: local-name( $j ) = 'aid'

Order:




Selection:

Name:

Simple Content: $j

Iteration:

Filter:

Order:











<result>
{
for $k in document("statisticsDB.xml")/statisticsDB/*
where local-name( $k ) = 'cityStatistics'
and $k/organization/cid = $k/financial/aid
return
for $i in $k/*
where local-name( $i ) = 'organization' or local-name( $i ) = 'financial'
return
   (
   if ( local-name( $i ) = 'organization' ) then
      for $j in $i/*
      where local-name( $j ) = 'cid'
      return
         $j
   else (),
   if ( local-name( $i ) = 'financial' ) then
      for $j in $i/*
      where local-name( $j ) = 'aid'
      return
         $j
   else ()
   )
}
</result>