XPath

Question

If I have XML:

Declare @XDoc xml
set @XDoc =
'<rws>
  <rw>
    <Customer>Janine</Customer>
    <Order>O1</Order>
  </rw>
  <rw>
   <Customer>Petru</Customer>
   <Order>O3</Order>
  </rw>
</rws>'

 

How do I get the following result with XPath query:

Customer        Order

-------------       ---------

Janine             O1

Petru              O3

 

Regards

Alwyn