how to combine XML table elements using XSD inline schema

[robsuttonjr]

in the following simple xml I would like an inline XSD schema that would allow me to define that note is a table that contains, name, address, city (from misc), and country. I have a more complex real world xml string which I trying to figure out how to throw fields from other areas into a particular table. I develop in foxpro and it allows me to convert xml to a table cursor. The issue right now is that if I simply convert the xml I get a bazillion tables. I want to get one table which I can add fields I want from other tables. Hope this makes sense.

<parent>
<note>
<name>Joe</name>
<address>123 main</address>
<country>usa</country>
<note>
<misc>
<city>slc</city>
</misc>
</parent>

Regards,

Rob