[xsl] Merge? Copy?

["sbz sbz" <sbz@xxxxxxxxxxxxxxxxx>]

I have an XML file similiar to below.  In this example I need the Customer to appear only once, in the real file it may be there once or 20 times.  I need the Sales data do be copied up from any duplicate customer. 

I have thought about doing this using vbscript maybe, but would prefer XSL to do it.  I have looked at merge but that requires loading 2 xml docs in.  I'd also prefer not have a duplicate xml file ... the file will be over 600 megs so loading two would be intensive.   

Is this even possible? 
Any tips would be appreciated.  Thank You. 

<Customers> 
<Customer id="100"> 
<Name></Name> 
<Address></Address> 
<Sales> 
<date>August 1, 2004</date> 
<amount>18</amount> 
</Sales> 
</Customer> 
<Customer id="100"> 
<Name></Name> 
<Address></Address> 
<Sales> 
<date>August 10, 2004</date> 
<amount>22</amount> 
</Sales> 
</Customer> 
</Customers> 

Desired Result: 

<Customers> 
<Customer id="100"> 
<Name></Name> 
<Address></Address> 
<Sales> 
<date>August 1, 2004</date> 
<amount>18</amount> 
</Sales> 
<Sales> 
<date>August 10, 2004</date> 
<amount>22</amount> 
</Sales> 
</Customer> 
</Customers> 

 




________________________________________________________________
Sent via the WebMail system at mail.masscreations.com