title: How to Use multiple conditions in Xpath?
body: <p>New to Xpath. Was trying in to use XML task in SSIS to load some values. Using Microsoft' XML inventory mentioned below.</p>
  
  <p>How can I load first-name value in bookstore/books where style is novel and award = 'Pulitzer'?
  <code>//book[@style='novel' and ./author/award/text()='Pulitzer']</code> is what I am trying. It gives the whole element. Where should I modify to just get the first-name value?</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;?xml-stylesheet type="text/xsl" href="myfile.xsl" ?&gt;
  &lt;bookstore specialty="novel"&gt;
    &lt;book style="autobiography"&gt;
      &lt;author&gt;
        &lt;first-name&gt;Joe&lt;/first-name&gt;
        &lt;last-name&gt;Bob&lt;/last-name&gt;
        &lt;award&gt;Trenton Literary Review Honorable Mention&lt;/award&gt;
      &lt;/author&gt;
      &lt;price&gt;12&lt;/price&gt;
    &lt;/book&gt;
    &lt;book style="textbook"&gt;
      &lt;author&gt;
        &lt;first-name&gt;Mary&lt;/first-name&gt;
        &lt;last-name&gt;Bob&lt;/last-name&gt;
        &lt;publication&gt;Selected Short Stories of
          &lt;first-name&gt;Mary&lt;/first-name&gt;
          &lt;last-name&gt;Bob&lt;/last-name&gt;
        &lt;/publication&gt;
      &lt;/author&gt;
      &lt;editor&gt;
        &lt;first-name&gt;Britney&lt;/first-name&gt;
        &lt;last-name&gt;Bob&lt;/last-name&gt;
      &lt;/editor&gt;
      &lt;price&gt;55&lt;/price&gt;
    &lt;/book&gt;
    &lt;magazine style="glossy" frequency="monthly"&gt;
      &lt;price&gt;2.50&lt;/price&gt;
      &lt;subscription price="24" per="year"/&gt;
    &lt;/magazine&gt;
    &lt;book style="novel" id="myfave"&gt;
      &lt;author&gt;
        &lt;first-name&gt;Toni&lt;/first-name&gt;
        &lt;last-name&gt;Bob&lt;/last-name&gt;
        &lt;degree from="Trenton U"&gt;B.A.&lt;/degree&gt;
        &lt;degree from="Harvard"&gt;Ph.D.&lt;/degree&gt;
        &lt;award&gt;P&lt;/award&gt;
        &lt;publication&gt;Still in Trenton&lt;/publication&gt;
        &lt;publication&gt;Trenton Forever&lt;/publication&gt;
      &lt;/author&gt;
      &lt;price intl="Canada" exchange="0.7"&gt;6.50&lt;/price&gt;
      &lt;excerpt&gt;
        &lt;p&gt;It was a dark and stormy night.&lt;/p&gt;
        &lt;p&gt;But then all nights in Trenton seem dark and
        stormy to someone who has gone through what
        &lt;emph&gt;I&lt;/emph&gt; have.&lt;/p&gt;
        &lt;definition-list&gt;
          &lt;term&gt;Trenton&lt;/term&gt;
          &lt;definition&gt;misery&lt;/definition&gt;
        &lt;/definition-list&gt;
      &lt;/excerpt&gt;
    &lt;/book&gt;
    &lt;my:book xmlns:my="uri:mynamespace" style="leather" price="29.50"&gt;
      &lt;my:title&gt;Who's Who in Trenton&lt;/my:title&gt;
      &lt;my:author&gt;Robert Bob&lt;/my:author&gt;
    &lt;/my:book&gt;
  &lt;/bookstore&gt;
  </code></pre>