<?xml version="1.0" encoding="UTF-8"?>
<Country>
  <States>
    <County>
      <popularity>39</popularity>
      <name>Orange</name>
      <id>13811</id>
      <url>http://www.url.gov</url>
      <overview>Orange County Overview</overview>
      <Cities>
        <City name="City #1" size="big" population="33333"/>
        <City name="City #2" size="medium" population="2222"/>
        <City name="City #3" size="Small" population="111"/>
      </Cities>
    </County>
  </States>
</Country>
What is the equivalent XPath expression of "select [cities] where [name]='Orange'" for the XML above?
Edit 07/27/09 00:29 AM PST:
I got it! Thank you all for the advices, you are are great teachers. I was able to select all attributes from all"City" with
/Country/States/County[name='Orange']/Cities/City