LINQ to XML perform distinct and join between files

Question

Hello all,

I am working with some large XML files using LINQ to XML. Now, a typical XML file returns:

• ID
• Name
• Image URL

I get a lot of duplicate information, I consider duplicate information to be data with the same ID ( it could have different a name and images and I don't mind). I want to distinct the values of the first XML file and perform a join with another file with a similar format.

How do I perform a distinct and a join at the same go? (The order is important, first distinct then join).

Thank you!