XML with two tables

[Satish]

HI

The XML below has two tables.They are Category and Products.
I need to get the Products when i select a Category
for eg:- when i mention "CAR" the i need to get "maruthi","santro" and "ford".
The relation between the two tables is "Category_Product".
I'm getting all the products.

Can any one Help me.

<?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>