select xml nodes rows

i am selecting list an xml buttress controlling t-sql. i name certain form node have quarrel combined any one.

for instance, suspect i am selecting people table. list an xml buttress addresses. xml formated identical following:

<address>
  <street>street 1</street>
  <city>city 1</city>
  <state>state 1</state>
  <zipcode>zip formula 1</zipcode>
</address>
<address>
  <street>street 2</street>
  <city>city 2</city>
  <state>state 2</state>
  <zipcode>zip formula 2</zipcode>
</address>

how i law this:

name         city         state

joe baker   seattle      wa

joe baker   tacoma     wa

fred jones  vancouver bc