xml - XQuery-连接查询

我有两个XML文件，想加入它们以获得所需的输出。
XML文件- 1

<Countries>
<Country>
   <No C="1"/>
   <Name>India</Name>
</Country>
<Country>
   <No C="2"/>
   <Name>USA</Name>
</Country>
<Country>
   <No C="3"/>
   <Name>Srilanka</Name>
</Country>
<Country>
   <No C="4"/>
   <Name>Thailand</Name>
</Country>
</Countries>

XML文件- 2

<Capitals>
  <Capital>
      <No C="1"/>
      <Name>New Delhi</Name>
  </Capital>
  <Capital>
      <No C="2"/>
      <Name>Washington DC</Name>
  </Capital>
  <Capital>
      <No C="3"/>
      <Name>Colombo</Name>
  </Capital>
  <Capital>
      <No C="4"/>
      <Name>Bangkok</Name>
  </Capital>
</Capitals>

所需输出-

India - New Delhi
USA - Washington DC
Srilanka - Colombo
Thailand - Bangkok

我所尝试的是，但无法获得所需的输出：（

for $x in doc('Country')/Countries
  return
  <a>
 {$x/Country/Name}
 {
   for $y in doc('Capital')/Capitals
   where $y/Capital/No/@C = $x/Country/No/@C
    return $y/Capital/Name
  }
  </a>

最佳答案

我得到了答案-
谓词中的双向连接-

for $x in doc('country')//Country
  return
  string-join( ($x/Name/text(),
     for $y in doc('capital')//Capital
       where $y/No/@C = $x/No/@C
       return $y/Name/text()
                ), " - ")