I would like to know how can I join two XML files as we used to do in databases. Say I have two XMLs like:
<Students>
<student>
<name>John</name>
<school id="1">NTU</school>
</student>
<student>
<name>Jame</name>
<school id="2">NUS</school>
</student>
</Students>
and
<schoolList>
<school id="1">
<name>NTU</name>
<address zipcode="111-2333"> Singapore</address>
<phone>566-1463</phone>
</school>
<school id="2">
<name>NUS</name>
<address zipcode="112-8610">Singapore</address>
<phone>3943-0987</phone>
</school>
</schoolList>
And the result I would like to get is:
<Seminars>
<seminar id=”1”>
<name>John</name>
<school id=”1”>NTU</school>
<address zipcode="111-2333"> Singapore</address>
<phone>566-1463</phone>
</seminar>
<seminar id=”2”>
<name>Jame</name>
<school id="2">NUS</school>
<address zipcode="112-8610">Singapore</address>
<phone>3943-0987</phone>
</seminar>
</Seminars>
Thanks


