Nested relation

[Satish]

HI

This is my XML file.So there are two tables in this.They are "Category" and
"product".The relation between these two tables is "Category_Product".
Actually with this relation iam getting the total products.How can i get the
details
of one Category products.for eg- Car Category,then i must get Maruthi,Santro
and
Ford. Can any one help me?

Satish

<?xml version="1.0" encoding="utf-8" ?>
<Catalog xmlns="http://tempuri.org/Products.xsd">
<Category>
<Name>Car </Name>
<Product>
<title>Maruthi</title>
<desc>Maruthi</desc>
<price>400000</price>
</Product>
<Product>
<title>Santro</title>
<desc>Santro</desc>
<price>600000</price>
</Product>
<Product>
<title>Ford</title>
<desc>Ford</desc>
<price>500000</price>
</Product>
</Category>
<Category>
<Name>Computer Peripherals</Name>
<Product>
<title>Moniter</title>
<desc>Moniter</desc>
<price>4000</price>
</Product>
<Product>
<title>Processor</title>
<desc>Processor</desc>
<price>6000</price>
</Product>
<Product>
<title>Mouse</title>
<desc>Mouse</desc>
<price>500</price>
</Product>
</Category>
</Catalog>