What is the best approach to merge(join) XML data?:
File#1:
<users>
<user>
<name>Mark</name>
<id>100</id>
</user>
<user>
<name>Fred</name>
<id>100</id>
</user>
</users>
File#2:
<users>
<user>
<id>100</id>
<lat>50</lat>
<lon>122</lon>
</user>
</users>
Desired output (only keep records where a match is found):
<users>
<user>
<id>100</id>
<lat>50</lat>
<lon>122</lon>
<name>Mark</name>
</user>
</users>
Thanks in advance!
M