two xml file calling one xsd file

[EDN Admin]

hi i am having two xml files one product.xml and other sales.xml
<?xml version="1.0" encoding="utf-8" ?><br/>
<productdetails><br/>
<product><br/>
<id>1</id><br/>
<name>cinthol</name><br/>
<price>200</price><br/>
</product><br/>
<product><br/>
<id>2</id><br/>
<name>liril</name><br/>
<price>300</price><br/>
</product><br/>
<product><br/>
<id>3</id><br/>
<name>hammam</name><br/>
<price>400</price><br/>
</product><br/>
</productdetails>
and other------------------------------------
<?xml version="1.0" encoding="utf-8" ?><br/>
<salesdetails><br/>
<sales><br/>
<salesid>1</salesid><br/>
<productid>1</productid><br/>
<salesqty>100</salesqty><br/>
</sales><br/>
<sales><br/>
<salesid>2</salesid><br/>
<productid>2</productid><br/>
<salesqty>150</salesqty><br/>
</sales><br/>
</salesdetails>

i want to create a xsd file inorder to join or create foreign key (for producttable and sales table),how i can do that <hr class="sig sidd

View the full article